Microsoft Build event announcements
Another Microsoft event and another bunch of exciting announcements. At the Microsoft Build event this week, the major announcements in the data...
2018-05-11
259 reads
Blog Posts
Mssql-cli Command-Line Query Tool
A recent announcement on the release of several SQL Server tools has raised expectations across various groups. Product requirements and business...
2018-05-11
896 reads
SQL Server Database Snapshots
What Are They
Database snapshots are a readonly point in time version of a database. You can use them for things...
2018-05-11
2,248 reads
YouTube Channel Update: 11 May 2018
I’ve been busy getting the videos up on YouTube. If they’re helpful to you, please subscribe. Some point soon I’ll...
2018-05-11
229 reads
Creating SQL Server Containers for versions 2012-2017
I am working on my dbatools and dbachecks presentations for SQL Saturday Finland, SQLDays, SQL Saturday Cork and SQLGrillen I want...
2018-05-10
361 reads
Database testing and ETL processes
Unit testing using tSQLt is really great, you call FakeTable on any tables your code touches and then insert the...
2018-05-10 (first published: 2018-05-01)
3,009 reads
Day 10 Option file
So far we have discussed various mays to configure MySQL, Environmental Variables, Global Variable, Session Variables, Status Variable and Server...
2018-05-10
213 reads
DMV To List Foreign Keys With No Index
I was entrusted with a new database for a critical application that was having general performance issue and the CPU...
2018-05-10
1,560 reads
Each session should be able to have its own temp table, but there can be problems.
You should be able to create a #temp in every session. That’s the idea, right? It’s one of the things...
2018-05-10
985 reads
Finding Tabs in SSMS–#SQLNewBlogger
Another post for me that is simple and hopefully serves as an example for people trying to get blogging as...
2018-05-10
470 reads
Blogs
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Who Are You Doing It For?
By Brian Kelley
But as I've matured over the years, I came to realize that I needed...
Presenting Twice in May 2026
By alevyinroc
I will be presenting my latest session, Documenting Your Work for Worry-Free Vacations, in-person...
Forums
How to change the FDLaunch Error log file location
The file FDLAUNCHERRORLOG gets created in the default <instance>\MSSQL\Log folder. So far, I've found...
what data type i should use for roversion col and can i use less than greater
can i use Rowversioncol ( in my database it's synonyme timestamp is used) to...
Radius Latitude Longitude
I have a table with latitude longitude in the format. 45.123456 , -111.123456 ,...
Question of the Day
A Fun Computer Quote
Which movie featured this quote?
"All programs have a desire to be useful."Happy April Fools! See possible answers