Blogs about: Sql Server 2008 R2

Featured Blog

Understanding SQL Server 2008 and 2008 R2

alliancetekinc wrote 11 hours ago: MS SQL Server is a comprehensive RDBMS (Relational Database Management System). MS SQL Server develo … more →

Tags: SQL Server 2008, data auditing, data security, outstanding performance, Storage and Data Warehousing, PowerPiviot for SharePoint and Excel, Multi Server Administration, Data-Tier Application., Master data

BI SQL # 125 : SQL Server DBA Scripts : SQL Script to find the List of blocked processes and time blocked for each blocking process!

Vishal Pawar 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 →

Tags: Link, Microsoft SQL Server, MSBI, Optimization, query, Script, SQL Mentalist, SQL PraRup, SQL Query

SQL Server 2008 R2 Cumulative Updates Released

Glenn Berry wrote 2 days ago: Microsoft has released two new Cumulative Updates for SQL Server 2008 R2. One is for SQL Server 2008 … more →

Tags: Cumulative Updates

BI SQL # 124 : SQL Server DBA Scripts : SQL Command to find the free space and used space of each file of a specific database!!

Vishal Pawar 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 →

Tags: query, Optimization, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Tricks

BI SQL # 123 : SQL Server DBA Scripts : Re-Indexing Script at Database Level

Vishal Pawar 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 →

Tags: query, Optimization, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query

SSIS Anchor Modeling example (tutorial)

Clint Huijbers wrote 5 days ago: About This Anchor Modeling SSIS example is brought to you by: Clint Huijbers (BumbleBI IT) Bas van d … more →

Tags: Anchor Modeling, AnchorModeling, BumbleBI, DWH, ETL, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2012

BI SQL # 122 : SQL Server DBA Scripts : Script to backup all Database in SQL Server

Vishal Pawar 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 →

Tags: SQL, query, Optimization, Link, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query

SQLTimer: a SQL Server Timer

Clint Huijbers wrote 1 week ago: So…you’ve got a fancy Business Intelligence (BI) solution? Predictive Analytics or perha … more →

Tags: SQL, SQL Server, T-SQL, Bi, Business Intelligence, SQL Server 2012, Predictive Analytics, BumbleBI, sql agent

BI SQL # 121 : SQL Server DBA Scripts : Script to identify tables without Primary Key

Vishal Pawar wrote 1 week ago: Hi Folks, In this article we are going to cover Script to identify tables without Primary Key. In th … more →

Tags: SQL, query, Optimization, Link, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Tricks

BI SQL # 120 : SQL Server DBA Scripts : How to Verify Backup before restoring it !

Vishal Pawar 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 →

Tags: Link, Microsoft SQL Server, MSBI, Optimization, query, Script, SQL Mentalist, SQL PraRup, SQL Query

Session Updates :TechEd 2013- DBI-B338 - Developing Hybrid Solutions with Microsoft BizTalk Server 2013 and Windows Azure-Video & features

Vishal Pawar wrote 1 week ago: Hi all, Following are few interesting session update from TechEd 2013. Hybrid Solutions with Microso … more →

Tags: General, BI Hot, live, Link, mobile BI, CRM, Job, Data Explorer, cloud

Sql Server: File cannot be shrunk as it is either being shrunk by another process or is empty

Sql Times 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 →

Tags: dba, Cool Script, Tips and Techniques, SQL Server 2008

BI SQL # 119 : SQL Server DBA Scripts : Get the total Rows, Reserved Space, Data, Index Size, and Unused Space of Table

Vishal Pawar 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 →

Tags: query, Optimization, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query

How To: Display unicode characters in Grid Results (SQL Server Management Studio - SSMS)

Clint Huijbers wrote 2 weeks ago: Is SSMS not displaying unicode characters? You might want to change the default font to: ‘Aria … more →

Tags: SQL Server 2005, SQL Server 2008, SQL Server 2012, ssms

BI SQL # 118 : SQL Server DBA Scripts : Find out the stored procedure which contain the selected Column name

Vishal Pawar 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 →

Tags: query, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query, Technology

Introducing SQL Server 2014 - Unlocking Real, Time Insights !!1 comment

Vishal Pawar wrote 2 weeks ago: Hi all Updates from SQL Server team Blog ! Microsoft has finally released some information during th … more →

Tags: Link, SQL Server, Microsoft SQL Server, query, SQL Query, new blog, TSql, SQL Mentalist, Vishal Pawar

BI SQL # 117 : SQL Server DBA Scripts : Find restored Date and Back up Date with Source file details

Vishal Pawar 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 →

Tags: query, Optimization, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query

BI SQL # 116 : SQL Server DBA Scripts : Find All Database table relation in 1-* format

Vishal Pawar 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 →

Tags: query, Optimization, Link, TSql, SQL Server, Microsoft SQL Server, Script, SQL Mentalist, SQL Query

Sql Server: MERGE statement (a powerful tool)

Sql Times wrote 2 weeks ago: Although the day started as just any other day, it is ending with a great surprise leaving much desi … more →

Tags: dba, Cool Script, Tips and Techniques, New Features, SQL Server 2008


Related Tags
All →

Follow this tag via RSS