Can I use SSDT for the 2008 BI stack?
SQL Server Data Tools (SSDT) that was released with SQL Server 2012 obviously works with the BI stack (SSIS/SSAS/SSRS) for...
2012-12-11
2,423 reads
SQL Live 360 Kicks off Today!
Hello Dear Reader! Today in beautiful Orlando FL at the Loews Royal Pacific Resort the Live 360 Conferencekicks off. Live...
2012-12-11
889 reads
T-SQL Tuesday #37 – A Month of Joins
It’s time once again for T-SQL Tuesday, and this month is hosted by SQLity.net, Sebastian Meine.
If you want to know...
2012-12-11
1,490 reads
SQL Server Disaster Recovery
I was reading a blog post by Steve Jones on Monday and I started to write a comment on his...
2012-12-11
1,102 reads
T-SQL Terminator
You may have noticed in my code examples, I always include a semicolon ";" at the end of my TSQL statements. ...
2012-12-11
1,034 reads
Move site collections to a new database or || split a content database
Hey Friends,
Sometime we may feel the need to move SharePoint site collection to new content db. Below step can be...
2012-12-11
966 reads
Reporting Services 2012 BI Training
Just wanted to get the word out that our SSRS 2012 training course is available. Are you looking for expert...
2012-12-10
1,537 reads
T-SQL Tuesday Topics
An Updated list of all the topics.
I was looking for a static list of all the T-SQL Tuesday topics and...
2012-12-10
1,614 reads
Copying Connection Managers in SSIS
Did you know you can copy and paste connection managers in SSIS? While I haven’t found this a huge benefit...
2012-12-10
1,568 reads
Practical SQL Server Performance Troubleshooting Day
Due to the huge demand of SQL Server Troubleshooting Know How and Techniques I’m running on January 29 (Vienna/Austria) and...
2012-12-10
1,200 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