SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-07
1,998 reads
Speaking at SQL Saturday Detroit on March 16
Ahhh – Motor City. What a fun place to start my 2013 SQL Saturday rounds! Detroit, here I come! You all...
2013-03-07
613 reads
Business Intelligence Projects now supported in Visual Studio 2012
Since the release of Visual Studio 2012, business intelligence developers have been limited in how much they could use this...
2013-03-06
1,561 reads
SQL Server – TSql to find Records matching certain criteria in all the tables of a DB.
Generally, we try to find out records matching a certain criteria from a single or few tables. However, there are...
2013-03-06
1,028 reads
Dropping Indexes
While working on some demos recently, I needed to drop an index for a test. I executed this generic statement...
2013-03-06
1,258 reads
Getting Started with Microsoft Data Explorer
What is Data Explorer
Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. ...
2013-03-06
1,084 reads
SSRS: Report Server Usage Report
While working with SSRS (SQL Server Reporting Service) it is very common to look into the Execution log to understand...
2013-03-06
2,576 reads
Visual Studio 2012 now supports BI!
My most popular blog has been Visual Studio 2012 does not support BI. In short, this means VS 2012 does...
2013-03-06
2,798 reads
SQL Server : Index Part 2 : Structure of Heap Tables
In the earlier post we tried to understand the difference between a table having clustered index and does not have a clustered...
2013-03-06
2,215 reads
Steps to Preload Data into Tables with SSDT
I am working as the data architect and developer on a modern app build with a the team from Modern...
2013-03-06
1,007 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
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers