An Overview on SQL Server Checkpoints
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part...
2015-01-26
15,063 reads
Blog Posts
An Overview on SQL Server Checkpoints
Commercial database systems like SQL server have many recovery mechanisms to restore data hardware or software failure. Checkpoints are part of such recovery mechanism.SQL Server Database Engine is programmed...
2015-01-26
10 reads
Downloading SQL Saturday data
I wanted to find out how many SQL Saturday’s I’d spoken at and how I ranked with others. I got...
2015-01-26
936 reads
Entity Framework 6 Entity/Property To Table/Column Names
I was recently working on some code where I needed to be able to go from an EntitySet name to...
2015-01-26
175 reads
Impact Player Series – Part 1
I wanted to start this series in regards to impact players that go above and beyond in the SQL Community....
2015-01-26
573 reads
RIGHT() function in SQL Server
Right():- This function returns the specified number of characters from the Right part of the given character string.Syntax:- Select RIGHT ( character_expression , integer_expression ) For example, the below query will...
2015-01-26
4 reads
SQL Saturday #397 Omaha – May 23
Omaha’s next SQL Saturday event, #397, is now live and scheduled for May 23rd, 2015, at Mammel Hall on the...
2015-01-26
669 reads
SSRS Farm to Scale-Out Performance
SSRS Farm Overview
Building a SSRS farm will require Enterprise or Business Intelligence editions of SQL Server for versions 2012 and...
2015-01-26
1,366 reads
T-SQL – Find Number of Rows of Database(s) tables Using Undocumented Procedure – sp_MSforeachdb and sp_MSforeachtable
On Technet forum, Op was looking for a way to get table cardinality for all databases in an instance. There are...
2015-01-26
784 reads
Availability Group Read-only Routing
This morning at a customer site I was researching an issue where Availability Group read-only routing was not working correctly. Quickly I was able to determine the issue was...
2015-01-25
7 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