SQL Server articles
Between attending SQL SKILLS immersion events, trying out for the PFE role at Microsoft I have managed to write some...
2016-03-16
173 reads
Arun Sirpal
Creating SQL databases on Azure Blob storage
Creating a database in SQL Server running in on-premises with a dedicated storage location for your data in Windows Azure Blob Storage.
2015-09-17
3,434 reads
An Extended Event script
I have been enjoying XE alot recently ( from following SQLSKILLS) so I decided to write something that I used recently...
2015-05-22
143 reads
Carving up CHECKDB
This is a technique that I am using from Paul Randal – concept of splitting CHECKDB: CHECKALLOC, CHECKCATALOG and CHECKTABLE – here...
2015-05-16
157 reads
Welcome to BlobEater
I am an IT Professional from the UK with a huge interest in MS technology especially SQL Server and Azure. During...
2015-03-25
295 reads
A Handy function
If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use...
2015-03-03
162 reads
Timed SQL Server tracing
Have you ever wanted to start a SQL trace (server-side trace!) from SQL agent and let it stop after X minutes...
2015-02-07
234 reads
2015-02-06
189 reads
Blogs
Top 5 SQL Server VM Performance Tuning Tips – Webinar Jul 21
By kleegeek
You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...
The Effectiveness of Solar Estimation
By Steve Jones
We added a solar system to the ranch as a way to hedge against...
How do I tell if identity_insert is turned on and if so what table?
TLDR; The code to do this is below but it’s a bit hokey and...
Forums
Shared Work Spaces: Hell, Heaven, Both?
Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...
T-SQL : Slicing time Islands and gaps
Hello, Consider the following table that gives the validity dates of an item :...
Migrate the SSIS Catalog in Just a Few Clicks
Comments posted to this topic are about the item Migrate the SSIS Catalog in...
Ask SSC