Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

0

The Magic Alt Button

Lately I have been using more and more the awesomeness of the Alt-button in SQL Server Management Studio (SSMS). What do I mean with this? While holding the Alt-button on your keyboard, you can select a block of text instead of lines of text. Note that this is not an exclusive feature, you can do […]

Read More...
0

Setup IaaS in Azure for SQL Server

Prior to full support for availability group listeners in Azure, we were forced to use availability groups without a key feature that makes them truly valuable – listener entry points.  A listener is the same concept as a cluster name in the FCI days.  Essentially, we look at a listener as the single point of […]

Read More...
4

Split a Query Window in SSMS

SQL Server Management Studio (SSMS) has a lot of cool little tips and tricks. Last night, while presenting for 24 Hours of PASS, I used the Window Split function and noticed a few “oohs” and “aaahs” on Twitter. Here’s how you do it. Open a query in SSMS. In this case, I was looking at […]

Read More...
0

Automated Database Deployments – Presentation Demos

This is an outline of the tools and scripts I used while demonstrating conversion of a sample “we make all our changes in production” database into a basic pipeline to verify and deploy changes automatically, as well as verify restores on a nightly basis. This post contains all of the steps, software, and scripts that […]

Read More...
0

September presentations

After an extended (to put it mildly) break from blogging, I’m back. One of the many reasons for less writing: more presentations!  (Another is violin lessons, but that’s another story.) Here is what I have upcoming in September. I hope you can join me for at least one! With PASS Summit fast approaching, PASS is […]

Read More...
1

Stupid me #4 – The login is from an untrusted domain

After quite a while it has finally returned: another Stupid Me™®©! A reminder: Every time I do something “stupid”, which happens from time to time, I’ll do a little blog post on what happened and how I solved it. The reason for this is twofold: I’ll have a solution online I can consult if it […]

Read More...
2

LobsterPot Solutions US

As many of you know, Rob Farley and I have been friends for quite a number of years.  You may have also seen Rob’s post on SQLBlog recently announcing that Rob and I have taken that friendship and longtime relationship, to the next level by bringing LobsterPot Solutions to the United States.  LobsterPot Solutions has […]

Read More...
2

Tableau Data Visualization Cookbook – Review

After my review of Tableau Dashboard Cookbook, I read another book about Tableau, namely Tableau Data Visualization Cookbook by Ashutosh Nandeshwar. The book is published by Packt but I am relieved to say this time there were no significant editing issues. In fact it is quite well written and as far as I could tell […]

Read More...
0

Client-side vs Server-side Validation in Web Applications

Validation exists to “ensure that the application is robust against all forms of input data” (owasp.org). Invalid data can cause unexpected execution errors, break assumptions elsewhere in your application, introduce errors into reporting, and even let someone hijack your service to attack others (script injection, sending spam, etc). When we’re talking about web form submission, […]

Read More...
0

Merge Replication for SQL Server Auditing

I recently had the pleasure of presenting for the Adelaide SQL Server User Group. I truly enjoyed the presentation and the group attending. The best part of this presentation is, it was on Merge Replication and all the great things we can accomplish with it. While setting up demonstrations for that presentation, I began to […]

Read More...
Next Page »