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
9 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
668 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,365 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
6 reads
Blogs
Git forked
Forgive me for the title. Mentally I’m 12. When I started my current day...
Setting FK Constraints in Data Modeler
By Steve Jones
One of the things a customer asked recently about Redgate Data Modeler was how...
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Forums
SSMS 22 Latest Update Crashing
Hi all, I've just had to roll back my SSMS 22 version from 22.3.0,...
Transactional Replication setup issue
Hi! I've been banging my head against the wall for 2 days now trying...
The Power of Data and Privacy
Comments posted to this topic are about the item The Power of Data and...
Question of the Day
What's the Date?
In SQL Server 2025, there is a new function that returns the current date without the time. What is it?
See possible answers