Archives: April 2012
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…
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)
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
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 -…
Measuring Internal Fragmentation
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
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…
“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
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
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
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.
there are 2 monitor tables after logshipping setup
This table has entries for all primary database on primary server and monitor server
This table has entries…
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…
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
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
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