Sparklines and Conditional Formating in SSRS
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
487 reads
Sparklines and Conditional Formating in SSRS
When creating a SSRS report, you want to add lines that display trends. You want to show trends for more...
2013-02-26
863 reads
Restart the SQL Server Agent Service using PowerShell
Just a quick one today chaps, to show how you can restart the SQL Server Agent Service using PowerShell.
Whilst covering...
2013-02-26
5,060 reads
SQL Server Videos
About two weeks ago, I wrote about SQL Server Podcasts and why I love that medium so much.
Today, I want...
2013-02-26
1,059 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” this Wednesday, Feb 27th at 11:00am CST to the PASS DBA virtual...
2013-02-26
948 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 9: Time Series
by Steve Bolton
The data mining method known as Time Series is aptly named, because it seems to take a...
2013-02-26
3,125 reads
SQL Server features that are not supported by Azure SQL Database
SQL Server is in the Cloud as Windows Azure SQL Database, but in the Cloud, still have some limitations that...
2013-02-26
6,804 reads
70-461 Test SQL Ranking Functions
I created a post-webinar SQL Ranking Functions interactive test which relates to 70-461 Exam and thought I will share it....
2013-02-25
1,837 reads
Webcast “Performance Impacts of User Defined Functions” This Week with Pragmatic Works
Functions might seem to be the answer to all of your desires to consolidate code, and at times they could...
2013-02-25
657 reads
SQL Server Discovery Report
How can I check what all SQL server features and version are installed on my Machine ?
It’s a frequently asked...
2013-02-25
1,568 reads
Blogs
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
The Book of Redgate: Evidence
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
Forums
Massive Table Growth Issue – How to Set Up Filegroup Usage Alerts?
Hello We recently encountered an issue where a SQL table unexpectedly grew in size...
The New World Of AI Robots
Comments posted to this topic are about the item The New World Of AI...
Logic question in a WHERE clause using IIF?
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Question of the Day
BIT_COUNT() V
What does this return on SQL Server 2025?
select bit_count(null)See possible answers