SQL SERVER 2012 - How to get a value from previous result row effectively
Reblogged from SQL Server Portal: I came across this query many times and most often we need the previous row...
2013-09-16
695 reads
Coffee and SQL
10 signs you're not talking to a developer
Reblogged from the pluralsight blog: There are many types of developers out there. And while not all speak the same...
2013-09-16
846 reads
70-457 Reviewer #12, Restoring SQL Server Databases
This lesson is the third and last part of topic for Managing Data which covers 20% of the certification exam....
2013-09-08
701 reads
70-457 Reviewer #11 Configuring and Maintaining a Backup Strategy
This topic is the second part for lesson Manage Data which covers 20% of the examination. Understanding Backup Types SQL...
2013-09-01
541 reads
70-457 Reviewer #10 Managing SQL Server Agent
This review topic is part of Managing Data lesson which covers 20% of the certification exam. SQL Server Agent enables...
2013-08-31
1,208 reads
Using DMV to identify sessions in your SQL Server
More than running sp_who2, which gives you more information than the good ol’ sp_who, or querying sys.dm_exec_sessions to check all...
2013-08-24
810 reads
Who’s doing what to your SQL Server?
When doing any kind of troubleshooting in your SQL Server first thing you ask is who is currently connected to...
2013-08-24
669 reads
Get the Backup History in your Central Management Server for SQL Server
I have a setup of Central Management Servers in my SQL Server and it’s been a big help to me...
2013-08-14
697 reads
70-457 Reviewer #09, Auditing SQL Server 2012
This review topic is still covered under the Optimize and Troubleshoot SQL Server lesson which covers 14% of the exam....
2013-08-13
584 reads
Deploying your SSIS Packages in SQL Server 2008
Prior to building and deploying your SSIS project to the SQL SSIS server, you need to build and create a...
2013-08-02
891 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Can You Let Go of Determinism
Comments posted to this topic are about the item Can You Let Go of...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers