Two simple commands that can be a big help in performance tuning.
The first thing that always comes to mind when discussing performance tuning is query plans and rightly so. They are...
2014-09-02
2,600 reads
SQL Server column encryption
We use databases to store a lot of information. This can also include sensitive information we don’t want to give...
2014-09-02
4,352 reads
The Nine SQL Server Careers
Microsoft SQL Server is a mature and broad technology platform that supports a diverse set of careers - this blog post...
2014-09-02
1,512 reads
Celebrating One Year of Heraflux Technologies
Our company, Heraflux Technologies, celebrated its first birthday today on September 1st. A very sincere thank you goes to all...
2014-09-02
520 reads
Last Weeks Top “Reading” Links #99
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-09-01
357 reads
September 2014 – SQL Server Monthly Maintenance Checklist
image source
It’s time for a monthly reminder to review you SQL Server environment. As with anything, just because it appears...
2014-09-01
511 reads
Business Intelligence Strategy – Beginning Steps
Business Intelligence Strategy
A business intelligence strategy is used to determine where an organization is and where they are going with...
2014-09-01
745 reads
Parameterization Part 3: Parameter Sniffing
This is the third post in the “Parameterization” series. In the previous post I mentioned parameter sniffing. This is a...
2014-09-01
1,403 reads
Reblog: August 22 to August 28
Photo credit – Husso
I’ve always been a fan of the feeling when I find an old blog post that’s got just...
2014-08-29
1,367 reads
Friday Followup For August 29, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-08-29
1,166 reads
Blogs
Automated SQL Server Benchmarking with HammerDB and Docker: A Complete Testing Framework
I’m excited to announce the release of a new open-source project that fully automates...
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...
Forums
AI Experience Gap that we keep talking about
Comments posted to this topic are about the item AI Experience Gap that we...
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...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers