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,425 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
890 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,492 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,105 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,037 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
975 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,616 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,569 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,201 reads
Blogs
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
Forums
Querying Multiple Tables for the Same Information
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Make It Routine
Comments posted to this topic are about the item Make It Routine
Finding Gaps in Sequential Data Using SQL Server
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
Question of the Day
Negative and Positive Numbers
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers