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,420 reads
James Serra's Blog
SQL Server Data Tools (SSDT) – November 2012 update
SQL Server Data Tools (SSDT) has a new update:
VS 2010: new version 10.3.21101.1, September version: 10.3.20905.0, initial version: 10.3.20225.0
VS 2012: new...
2012-12-06
2,989 reads
Power View for Multidimensional Models – Preview Available
Microsoft introduced an interactive data exploration, visualization and presentation experience called Power View with SQL Server 2012. Power View can only consume data...
2012-11-30
2,386 reads
Reasons not to upgrade to SQL Server 2012
As exciting as SQL Server 2012 is, with its multitude of new features, it’s not always possible to upgrade right...
2012-11-29
2,846 reads
Billing rates – other side of the fence
The following is a guest post by Tim Morgan from Sullexis in response to a resent blog of mine:
Thanks for letting...
2012-11-27
1,678 reads
Master Data Services Web Services API Error
In Master Data Services (MDS), I received an error when using C# code in the script task in SSIS 2012...
2012-11-20
1,050 reads
PASS 2012 Announcements
Some announcements and notes from the SQL PASS Summit 2012 last week (If you don’t know what PASS is, check out What is SQL...
2012-11-15
1,165 reads
Data Warehouse Architecture Presentation Slides
Thanks to everyone who attended my “Data Warehouse Architecture” presentation to the South Florida PASS chapter.
Here is the PowerPoint presentation: Data Warehouse...
2012-11-15
1,693 reads
Dell Quickstart Data Warehouse Appliance 2000
As a follow-up to my blog Dell Quickstart Data Warehouse Appliance for SQL Server 2012, Dell announced the availability of the second...
2012-11-13
904 reads
Data Warehouse Architecture Presentation
I will be presenting the session “Data Warehouse Architecture” to the South Florida PASS chapter on Wednesday, Nov 14th, at...
2012-11-12
1,034 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
SSRS Reminded Me of the Time Microsoft Retired TMG
Comments posted to this topic are about the item SSRS Reminded Me of the...
Getting results from a Procedure to join to a query
I have a need to execute a stored procedure and return the results to...
Upgrade 2016 Standard to 2022 Express
Title pretty much says it all - can this be done? I've tried several...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers