The affordable self-service BI revolution has started.
I am officially announcing that I have now become an independent consultant and business owner. Becoming independent has always been...
2012-01-30
1,871 reads
Afterthoughts: IT Pro Camp Orlando 2012
This past Saturday January 21, 2012 I had the opportunity to speak at my first IT Pro Camp in Orlando,...
2012-01-24
874 reads
Codeplex: SSIS Community Tasks and Components
I recently bumped into this very exhaustive list of SSIS tasks, components and samples in CodePlex http://ssisctc.codeplex.com. The list is maintained by...
2011-12-14
1,305 reads
Master Data Services Error: Resolving from a long-running stucked Staging Batch with Status “Queued to Clear” or “Not Running”
In some ocassions, you may run into a runaway, long-running or stucked staging batch with Master Data Services in SQL Server 2008...
2011-12-14
1,578 reads
SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.
Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error...
2011-11-29
1,734 reads
SQL Saturday 86 BI Edition Tampa 2011: Afterthoughts
Wow! Just Wow! That’s all I can say to describe how great SQL Saturday 86 was on November 5th in Tampa,...
2011-11-16
1,275 reads
The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.
Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my...
2011-11-16
1,876 reads
GiveCamp Tampa 2011
This past weekend I participated at GiveCamp Tampa 2011 (http://www.givecamptampabay.org/) as part as the Worldwide GiveCamp (http://www.givecamp.org) weekend sponsored by...
2011-10-24
1,016 reads
Todo lo que debes saber sobre SSIS en 1 hora!
Gracias a lo asistentes de mi charla Todo lo que debes saber sobre SSIS en 1 hora! en el evento...
2011-10-20
1,314 reads
MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table
Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line...
2011-10-11
1,005 reads
Blogs
Export a Power BI Report that cannot be Downloaded
Yes, you’re reading that right, we’re going to download a report that cannot be...
Query Intelligence in SQL Server 2025: What Developers Need to Know
By Chris Yates
When Microsoft announced SQL Server 2025, I was curious about what would truly change...
Finding and Killing Blockers with Redgate AI Tech
By Steve Jones
Redgate has a research arm, called the Foundry, that has been experimenting with AIs...
Forums
Poor Name Choice
Comments posted to this topic are about the item Poor Name Choice
Getting the Indexed Columns
Comments posted to this topic are about the item Getting the Indexed Columns
T-SQL in SQL Server 2025: Substring Changes
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Question of the Day
Getting the Indexed Columns
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers