Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: 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.
http://technet.microsoft.com/en-us/library/ms187016.aspx

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

Read more

0 comments, 3,233 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, 507 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

5 comments, 487 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, 297 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, 430 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

15 comments, 6,633 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, 401 reads

Posted in Tim Radney - Database Professional 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, 458 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

2 comments, 1,675 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, 345 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, 427 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, 731 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

1 comments, 895 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, 1,423 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, 1,930 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

0 comments, 761 reads

Posted in James' SQL Footprint on 18 April 2012

Urgent BIOS Update for Dell PowerEdge R810, R910 and M910 Servers

If you have an 11th generation Dell PowerEdge R810 , PowerEdge R910 server, or a PowerEdge M910 blade server, there is a pretty recent (April 9, 2012) Urgent update to version 2.7.0 for the main system BIOS. Here is Dell’s description of the update:

Dell highly recommends applying…

Read more

4 comments, 1,180 reads

Posted in Glenn Berry's SQL Server Performance on 18 April 2012

sys.sql_modules vs. INFORMATION_SCHEMA.Routines

Consider the following two queries meant to search for a keyword in SQL programmability objects.

select s.name +'.' + o.name, o.type_desc, m.definition
from sys.sql_modules m
inner join sys.objects o on m.object_id = o.object_id
inner join sys.schemas s on s.schema_id = o.schema_id
where definition like '%dataserver2%'
order by o.name

select r.SPECIFIC_SCHEMA…

Read more

1 comments, 868 reads

Posted in SQL Tact on 18 April 2012

Microsoft Certified Solutions Associate – SQL Server 2008 Core / Windows Server® 2008

Yesterday, I received two mails from the Microsoft Certification Program Team about two new certification earned:

1. Microsoft Certified Solutions Associate – SQL Server 2008 Core

2. Microsoft Certified Solutions Associate – Windows Server® 2008

 

These also reflected on my transcript today. These two new certifications are awarded due… Read more

1 comments, 967 reads

Posted in SQL and Me on 18 April 2012

Visualize Wait stats with Microsoft Excel

In our blog post last week: Instance Wide Wait Stats we promised to show You how to visualize the collected wait stats with Microsoft Excel, so this is what this blog post will be about.

The blog post from last week will be the basic setup for this one, so… Read more

0 comments, 585 reads

Posted in SQL Server Notes from the Field on 18 April 2012

Newer posts

Older posts