Monitoring blocking and deadlocking with Extended T-SQL Collector
Monitoring blocking and deadlocking hasn’t always been easy. Sometimes, the tools available in SQL Server are not as friendly as...
2014-12-12
1,838 reads
Blog Posts
Preparing a Technical Session Part 1: Picking a Topic
So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you...
2014-12-12 (first published: 2014-12-02)
5,390 reads
Reblog: December 5 to December 11
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-12-12
701 reads
SQL Bits – Europe’s largest SQL Conference
4th 7th March
ExCeL Centre in London, England
SQLBits have announced their dates for 2015.
I have been three times and...
2014-12-12
1,403 reads
T-SQL Tuesday #61 – Giving Back
It just seems to me that these block parties of T-SQL Tuesday come quicker each month. I’m always thrilled when...
2014-12-12 (first published: 2014-12-09)
4,587 reads
DROP INDEX and CREATE INDEX vs ALTER INDEX REBUILD
I saw someone ask a few weeks ago if it was faster to drop and re-create an index or do...
2014-12-11
3,415 reads
T-SQL Tricks – Customizing SSMS Templates with Parameters
I wrote briefly about templates in Management Studio (SSMS), and showed the default templates that come with SQL Server. I...
2014-12-11 (first published: 2014-12-03)
7,052 reads
Video – Identifying large queries using Extended Events
A couple of weeks ago I was contacted by Webucator (an online training company) asking if they could use my...
2014-12-11 (first published: 2014-12-05)
2,363 reads
Converting Dates
I ran across a post recently where someone had dates stored as characters (never good), but also in this format:...
2014-12-10
858 reads
On Perspective
Perspective can make or break a career. Maintaining a proper perspective is very often the differentiating factor between a good...
2014-12-10 (first published: 2014-12-03)
5,655 reads
Blogs
How to Parameterize Fabric Linked Services in Azure Data Factory for Azure Devops Deployment
Quite the title, so let me set the stage first. You have an Azure...
Deployment Pipelines in Fabric – What Are They?
By HeyMo0sh
In the realm of software development and content creation, the deployment pipeline serves as...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers