SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: April 2012

2012 DDL for Roles


I’m extremely pleased that Microsoft are continuing their commitment to provide full DDL to preform TSQL operations that have previously been preformed using stored procedures.

The particular case that I came across today was regarding roles and the ALTER ROLE syntax.

Prior to SQL SERVER 2012, it has… Read more

0 comments, 1,250 reads

Posted in measure twice, cut once. on 22 April 2012

SQLSaturday in Houston Presentation

Thanks to everyone who attended my presentation “Scaling SQL Server to HUNDREDS of Terabytes” at Houston SQLSaturday.

Here is the PowerPoint presentation: Scaling SQL Server to HUNDREDS of Terabytes

Scaling SQL Server to HUNDREDS of Terabytes

Learn how SQL Server 2008 can scale to HUNDREDS of terabytes for BI… Read more

3 comments, 833 reads

Posted in James Serra's Blog on 22 April 2012

Setup database mirroring and log shipping together

SQL Server has multiple high availability solutions. Comparing with cluster, database mirroring and logshipping are easier to setup, and they don't need special hardware.

here is a great article about how to setup the database mirroring and log shipping together.

In our system, we setup data mirroring with high-safety…

Read more

4 comments, 10,545 reads

Posted in James' SQL Footprint on 21 April 2012

SQL Saturday Houston #107 - SQL Server Best Practices with DMV Presentation Files

Thanks for joining me for a standing room only presentation this morning at 9:45am at SQL Saturday #150 Houston.  This is the second year speaking at SQL Saturday Houston and the event was one of the best I've been to, kudos to the organizers.  I was especially impressed that all…

Read more

0 comments, 783 reads

Posted in SQL Tact on 21 April 2012

Temporary Post Used For Theme Detection (a2bb2736-7786-4122-aa80-2ea5c4a91819 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

This is a temporary post that was not deleted. Please delete this manually. (a9a8917a-7430-47c6-8534-f96e3e4e0618 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)

Read more

0 comments, 730 reads

Posted in Cleveland DBA on 21 April 2012

Im in Houston Today (and this weekend too)

I’ll be spending the day with the 2011 Idera ACE’s (aka the old aces) and the 2012 Idera ACES (the new ones!) as we share lessons learned, work on being better at presenting and networking, and in general talk about ways to have a positive impact. Then tonight I’ll be… Read more

0 comments, 634 reads

Posted in SQLAndy on 20 April 2012

SQL Script Toolbox for Developers

I work with a motley crowd of developers and have the opportunity to give lunch and learn training sessions on SQL Development.

Most recently, I put together a .zip file of T-SQL scripts that developers would find handy.  You can download it here.

Here's a summary:

Missing Indexes -…

Read more

0 comments, 637 reads

Posted in SQL Tact on 20 April 2012

SQL Server: Measuring The Index Fragmentation

In my previous post , I have explained about the different types of fragmentation and how it will affect the query performance. In this post we will discuss about measuring the index fragmentation.

Measuring Internal Fragmentation 

Internal fragmentation  is all about the fullness of the page and it is measured using…

Read more

23 comments, 10,617 reads

Posted in PracticalSQLDba on 20 April 2012

Spend two hours with me at #sqlsat107.

In just two days SQL Saturday 107 will be in full swing.  Tomorrow begins their precon with the infamous Kalen Delaney.  Those who were lucky enough to sign up and get one of the coveted spots are in for a treat.  Thanks to the Idera ACE program I was blessed… Read more

0 comments, 602 reads

Posted in Tim Radney - Database Professional on 19 April 2012

CONCAT in SQL 2012

SQL Server 2012 introduces a brand new string function called CONCAT(). CONCAT() string function allows you to concatenate up to 255 string or variable values in to one single string. It requires a minimum of two input values when calling the function and takes care of implicitly converting the data…

Read more

0 comments, 387 reads

Posted in SQL & BI on 19 April 2012

script system object in resource database

When I troulbshooting the logshipping problem, I found many logshipping store procedure can not be found in the master or msdb database. for instance, in the master. [sys].[sp_add_log_shipping_secondary_primary] , it calls sys.sp_MSprocesslogshippingjob to create the copy job, however, sys.sp_MSprocesslogshippingjob is in the resource database, we can not review its code with sp_helptext command.

Read more

0 comments, 898 reads

Posted in James' SQL Footprint on 19 April 2012

Using sys.dm_exec_requests to find a blocking chain and much more

As with every good DBA's toolbox, my blocking list query using sys.dm_exec_requests is evolving.

I've added the following features:

  • The query execution plan of the active request in the QueryPlan column to the right.
  • Variable at the top which changes the relationship of the join between sys.dm_exec_sessions and  sys.dm_exec_requests. 
    • When set…

Read more

3 comments, 3,164 reads

Posted in SQL Tact on 19 April 2012

Great User Group Meeting Tuesday, Now on to Madison and SQL Saturday #118

Minnesota SQL Server User Group Meeting Review (4/17/12) First of all, I have to thank the awesome speakers who presented at our user group meeting on Tuesday night, April 17.  Mark Souza ( T | B ) for a great question and answer session.  He was open about SQL Server…

Read more

3 comments, 531 reads

Posted in DataOnWheels on 19 April 2012

Becoming the dumbest guy in the group

“Why I joined Linchpin People as a Teammate”

It was announced publicly this past weekend at SQL Saturday #111 that I have joined Linchpin People as their first teammate.  My friend Andy who is also a Chief Servant Officer of Linchpin made the announcement during the speaker dinner and gave… Read more

4 comments, 711 reads

Posted in Tim Radney - Database Professional on 19 April 2012

Why Isn’t There A Deployment Server Edition For SSIS Projects?

Andy Leonard blogged about a gotcha when creating SSIS projects using SSDT yesterday. He showed that you can use any component in SSDT whether or not your SQL Server supports that component. For example, you can create a package with Fuzzy Lookup and deploy to a server running Business Intelligence… Read more

0 comments, 1,398 reads

Posted in Sam Vanga on 19 April 2012

More IMPORTANT miscellaneous info


This is a first blog for this month, yes I was busy with Powershell quiz and some other personal stuff.

Okay, continue with Miscellaneous Info
here is some more important stuff/ information about sql server.

>>Ghost cleanup task runs every 5minuts (in 2005) and runs every 10minuts in (2008… Read more

0 comments, 1,223 reads

Posted in Vinay Thakur on 19 April 2012

PowerShell: Using Exponents and Logs to Format Byte Sizes

In a recent Scripting Games event, I had to format some byte values into their most appropriate size according to how many bytes were present. Anyone who hangs around with me long enough will realize I love numbers and the preciseness that they provide. This is one of many reasons…

Read more

3 comments, 3,098 reads

Posted in Kyle Neier on 19 April 2012

SQL Server 2012 Performance Test: Gap Detection

Next up on the SQL Server 2012 Performance testing circuit: Gap Detection. You know, where you find missing values from a table of sequential numbers.

SQL Server 2012 introduces the LEAD function, which I’ve previously blogged about here. In that blog post, I covered how to do Gap Detection… Read more

7 comments, 3,068 reads

Posted in A Discussion of SQL Server-Related Topics on 19 April 2012

Log shipping setup problem

Last week, our log shipping setup had a problem, so I spent some time to dig into the log shipping.

there are 2 monitor tables after logshipping setup
1. log_shipping_monitor_primary
      This table has entries for all primary database on primary server and monitor server

2. log_shipping_monitor_secondary 
      This table has entries…

Read more

1 comments, 1,891 reads

Posted in James' SQL Footprint on 18 April 2012

Welcome IIF() to SQL Server Family

IIF() function is new to SQL Server family of functions. It is a brand new logical function being introduced with SQL Server 2012 that allows you to perform IF..THEN..ELSE condition within a single function. This helps in simplified code and easy to read conditions.

In earlier versions of SQL Server,…

Read more

0 comments, 191 reads

Posted in SQL & BI on 18 April 2012

Newer posts

Older posts