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,261 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,085 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,586 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,801 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,216 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
That’s Actually A Duplicate Index
As I’ve worked with clients on performance tuning through index improvements, one of the common areas that I discuss with...
2013-03-06
2,445 reads
Upgrading to SQL Server 2012?
Do you have any plans in place to upgrade to SQL Sever 2012 this year. We are now well into...
2013-03-06
1,058 reads
Blogs
To refer and to be referred
Referrals have never been more important in the job market. They’re no longer nice...
A New Word: Dorgone
By Steve Jones
dorgone– adj. wondering if you could slip away from an event or group conversation...
Tell It Once: Setting Up Claude With Skills and MCP Servers
By ReviewMyDB
Many of us use AI the same way every single day. Open a tab....
Forums
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...
Negative and Positive Numbers
Comments posted to this topic are about the item Negative and Positive Numbers
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