I’m A Friend Of Red Gate For 2015
I was excited to learn this week that I’ve been chosen as a participant in the Friends of Red Gate...
2015-01-23
562 reads
Blog Posts
Technology Advances – mSATA external case
I had an SSD die last year. It was one of my traveling SSDs, where I keep spare copies of...
2015-01-23 (first published: 2015-01-16)
6,620 reads
Video: A Better Way to Reindex
Sean presented A BETTER WAY TO REINDEX for the Performance Virtual Chapter. Here are links to the video, and to...
2015-01-23
1,941 reads
Excel Apps – Not Quite Ready for Primetime
While this is not a regular Excel tip, but it is about Excel. In my Excel BI Tips series, I...
2015-01-22
1,103 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance 1) Start the setup > Go to Installation from Left > Click on 1st option of New SQL Server standalone edition...
2015-01-22
12 reads
How to install standalone SQL Server 2012 instance ?
Steps to install standalone SQL Server 2012 instance
1) Start the setup > Go to Installation from Left > Click on 1st option...
2015-01-22
1,077 reads
Looking Out for Others Helps You Lead
I'm sitting on a plane. I'm in an exit row, still a big guy in a little seat. I go...
2015-01-22
802 reads
Pagination in SQL Server
It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL...
2015-01-22 (first published: 2015-01-15)
8,939 reads
SQL #57–A one-liner query with PARTITION BY
What can be done in SAS must be possible in SQL
A friend of mine is a data professional in marketing data...
2015-01-22 (first published: 2015-01-17)
10,463 reads
SQLPort’s new image
After almost 5 years of existence, SQLPort (Portuguese PASS Chapter in Lisbon) is kicking of 2015 with a renewed image...
2015-01-22
533 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