SQL Server 2012 (“Denali”): Power View installation and requirements
Power View is installed when you run the SQL Server 2012 install and on the Feature Selection page choose “Reporting...
2012-03-09
3,121 reads
Blog Posts
SSAS Tabular Model – Query Modes
One of the most compelling features of the new SSAS Tabular Model is the ability to set the model’s Query...
2012-03-09
2,983 reads
Traveling More Than Expected
For a guy that was looking to not travel much, it seems that I’ve got way more on my plate...
2012-03-09
1,021 reads
Why Support WIT
First, only support Women in Technology if you want to. It’s an idea that appeals to some, but not to...
2012-03-09
962 reads
Converting SQL SERVER DateTime? Test it thoroughly….
Today one of my user complained that a report was missing one particular ticket from the output. The report in...
2012-03-08 (first published: 2012-02-28)
4,292 reads
Let’s Talk
I’m travelling to several upcoming events and I’d love to sit down and talk with you. Yes, I get it,...
2012-03-08
880 reads
March 2012 – Monthly SQL Server Checklist
Are your SQL Servers healthy? If the things went south today today, would you be able to say you can...
2012-03-08
1,774 reads
March Madness – SQL Server style
Bodypaint not required
It seems that March is another great month for getting your geek on without having to leave the...
2012-03-08
646 reads
Moving MASTER Database
In my previous post we see how to move MSDB database, today we will see how to move or relocate...
2012-03-08
1,083 reads
SQL Server – netstat monitoring and tuning performance
To display network connections and various network interface statistics – netstat is a handy command – line based tool.
Why is it...
2012-03-08
1,327 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