Blogs about: Sql Server 2008 R2
Featured Blog
T-SQL Script to find out the database file size, space used and available free space
While troubleshooting disk space issue, it is essential to know about the database file size statistics. You can execute below script to get database file size information. set nocount on create table… more →
Understanding SQL Server 2008 and 2008 R2
wrote 11 hours ago: MS SQL Server is a comprehensive RDBMS (Relational Database Management System). MS SQL Server develo … more →
BI SQL # 125 : SQL Server DBA Scripts : SQL Script to find the List of blocked processes and time blocked for each blocking process!
wrote 22 hours ago: Hi Geeks, In this article we are going to cover SQL Script to find the List of blocked processes and … more →
SQL Server 2008 R2 Cumulative Updates Released
wrote 2 days ago: Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 … more →
BI SQL # 124 : SQL Server DBA Scripts : SQL Command to find the free space and used space of each file of a specific database!!
wrote 2 days ago: Hi Geeks, In this article we are going to cover SQL Command to find the free space and used space of … more →
BI SQL # 123 : SQL Server DBA Scripts : Re-Indexing Script at Database Level
wrote 4 days ago: Hi Geeks, In this article we are going to cover Re-Indexing Script at Database Level. In this post w … more →
SSIS Anchor Modeling example (tutorial)
wrote 5 days ago: About This Anchor Modeling SSIS example is brought to you by: Clint Huijbers (BumbleBI IT) Bas van d … more →
BI SQL # 122 : SQL Server DBA Scripts : Script to backup all Database in SQL Server
wrote 6 days ago: Hi Geeks, In this article we are going to cover Script to backup all Database in SQL Server. In this … more →
SQLTimer: a SQL Server Timer
wrote 1 week ago: So…you’ve got a fancy Business Intelligence (BI) solution? Predictive Analytics or perha … more →
BI SQL # 121 : SQL Server DBA Scripts : Script to identify tables without Primary Key
wrote 1 week ago: Hi Folks, In this article we are going to cover Script to identify tables without Primary Key. In th … more →
BI SQL # 120 : SQL Server DBA Scripts : How to Verify Backup before restoring it !
wrote 1 week ago: Hi Geeks, In this article we are going to cover How to Verify Backup before restoring it ! In this p … more →
Session Updates :TechEd 2013- DBI-B338 - Developing Hybrid Solutions with Microsoft BizTalk Server 2013 and Windows Azure-Video & features
wrote 1 week ago: Hi all, Following are few interesting session update from TechEd 2013. Hybrid Solutions with Microso … more →
Sql Server: File cannot be shrunk as it is either being shrunk by another process or is empty
wrote 1 week ago: A few days ago, on one of the production database servers we ran into space issue. One of the databa … more →
BI SQL # 119 : SQL Server DBA Scripts : Get the total Rows, Reserved Space, Data, Index Size, and Unused Space of Table
wrote 1 week ago: Hi Geeks, In this article we are going to cover How to Get the total Rows, Reserved Space, Data, Ind … more →
How To: Display unicode characters in Grid Results (SQL Server Management Studio - SSMS)
wrote 2 weeks ago: Is SSMS not displaying unicode characters? You might want to change the default font to: ‘Aria … more →
BI SQL # 118 : SQL Server DBA Scripts : Find out the stored procedure which contain the selected Column name
wrote 2 weeks ago: Hi Geeks, In this article we are going to cover How to Find out the stored procedure which contain t … more →
Introducing SQL Server 2014 - Unlocking Real, Time Insights !!
— 1 comment
wrote 2 weeks ago: Hi all Updates from SQL Server team Blog ! Microsoft has finally released some information during th … more →
BI SQL # 117 : SQL Server DBA Scripts : Find restored Date and Back up Date with Source file details
wrote 2 weeks ago: Hi Folks, In this article we are going to cover How to Find restored Date and Back up Date with Sour … more →
BI SQL # 116 : SQL Server DBA Scripts : Find All Database table relation in 1-* format
wrote 2 weeks ago: Hi Geeks, In this article we are going to cover How to Find All Database table relation in 1-* forma … more →
Sql Server: MERGE statement (a powerful tool)
wrote 2 weeks ago: Although the day started as just any other day, it is ending with a great surprise leaving much desi … more →
