Get Inspired – SQL Inspire 2011 New York
Coming up next week is the SQL Inspire 2011 event in New York City. It’s an event with a number...
2011-11-01
1,683 reads
Blog Posts
Log file size after backup and restore
Quick summary of the post:
A restoration of a full database backup retains the log file size before restoration.
Now...
2011-11-01
524 reads
November Question: What is your favorite, and not so favorite hardware to run SQL Server on?
Selecting which hardware to run SQL Server on is often discussed among DBAs. So, for this month’s question, “What is...
2011-11-01
506 reads
Presenting on SQL Internals, Recovery Models, & Backups! OH MY Today
Today I’m presenting “SQL Internals, Recovery Model’s, and Backups. OH MY!”, for Pragmatic Works. I did this presentation once before...
2011-11-01
498 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are...
2011-11-01
741 reads
Quick and Dirty Index Info
From time to time, somebody needs to find some information about the indexes in the database. As DBA’s, there are a few tools at your disposal to look up...
2011-11-01
15 reads
SQL Server Release Services Blog and TechDays 2011- Places Worth Watching (Oh, & In Case You Missed it, SQL 2008 SP3 Was Already Released :)
Yes, SQL Server 2008 SP3 is out ...
TechDays 2011 SQL Server and Data Platform Track
2011-11-01
1,017 reads
SQL Tribal Knowledge
Calling all unpublished* SQL Server folk!
I’m now accepting abstracts for a new project we’re putting together – a community-written book of...
2011-11-01
873 reads
Document Your Day
You should be documenting your day, your week, your month, on a regular basis. Take a few minutes when you...
2011-10-31
2,659 reads
Four faces of an Employee
Whoever starts their career in any domain/technology, initially they will have two faces.
First face of an employee is to take...
2011-10-31
1,743 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers