PowerShell to create Azure SQL DBs
Recently I have been creating many Azure SQL databases via the portal where I started to find it quite tedious. So...
2016-09-14
515 reads
Arun Sirpal
Query Performance Insight
It is really easy getting insight into Query performance within your Azure SQL DB. I think Microsoft have done a...
2016-09-12
759 reads
DBCC HELP
I was going through some online courses and came across Erin Stellato’s Course on DBCC commands.http://www.sqlskills.com/blogs/paul/new-course-understanding-and-using-dbcc-commands/ I learnt something new!...
2016-09-09
545 reads
CHECKDB is slow!
Running the usual consistency checks on a database (with a new release code applied from an ISV) I noticed slower...
2016-09-01
405 reads
Talking of checkpoint
I was having a conversation with someone over a disgusting vanilla latte and we talked about shutting down a machine...
2016-08-25
189 reads
Do YOU Checksum?
I am going to show you why you should be using checksum options on your backups (and restores). I AM...
2016-08-11
202 reads
2016-08-05
186 reads
Undocumented Commands
There isn’t really a need to do what I am doing in this blog post but I guess one reason...
2016-08-03
201 reads
Migrating SQL Server to Azure
There are many ways to migrate an “earthed” SQL Server database to Azure, for this article I want to show...
2016-08-02
223 reads
Why I like SQL Sentry Plan Explorer
Why I like SQL Sentry Plan Explorer. I am going to be honest here, before attending SQLSKILLS Immersion training I...
2016-07-29
640 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