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.

LTD Social Sitings

Lessthandot twitter Lessthandot Linkedin Lessthandot facebook Lessthandot rss

Note: Watch for social icons on posts by your favorite authors to follow their postings on these and other social sites.

Discuss Share Learn

Top Forum Users

The top ranked users for the past 30 days:

Google Ads

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...
0

Modeling the Agile Data Warehouse with Data Vault – Review

A few months ago I followed an introductory course about the data vault modeling technique for data warehouses at a local training provider. As part of the training, I received the book Modeling the Agile Data Warehouse with Data Vault written by Hans Hultgren who also is an instructor for the official data vault certification. […]

Read More...
Next Page »