CDC Interoperability with Mirroring and Recovery
CDC Interoperability with Mirroring and Recovery
The following email came in to a discussion group last week asking several questions about...
2010-11-29
2,357 reads
Cleaning Up Blogs
I highly encourage people to blog. I know that not everyone is a writer, but I think that blogging helps...
2010-11-29
1,596 reads
Blog Round-up – What Are You Thankful For?
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,214 reads
Buried
Coming back after a week off, even a holiday week when traffic is relatively low, is no fun. I have...
2010-11-29
1,478 reads
Using DMVs to Find the Ports that SQL Server is Listening On
The other day I was asked to provide the port number that a SQL Server instance was listening on. As...
2010-11-29
3,372 reads
Lock escalation : SQL Server 2008
Lock escalation is a event which occurs when SQL Server decides to upgrade a lock at a lower level hierarchy...
2010-11-29
1,331 reads
Determining An Enterprise Execution Policy Setting
Windows PowerShell has the concept of execution policy that determines in which cases script and configuration files are able to...
2010-11-28
2,369 reads
New Domain - My blog has a new domain name gethynellis.com
About a year ago I started to write a blog, previously to that, for about three years I had been...
2010-11-28
620 reads
SQL Server 2008 R2 Best Practices Analyzer
A big part of my DBA career has centered around identifying and sharing SQL Server DBA best practices. There are...
2010-11-27
2,654 reads
Do You Protect Your Passwords?
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
680 reads
Blogs
Excellent article on securing msdb
By Brian Kelley
Fabiano Amorim has written an excellent article at Simple Talk on securing msdb. Here's...
T-SQL Tuesday #201: Temp Tables
By Steve Jones
This month we have a new host, which I am grateful for. So many...
When Do You Reach For A #temp Table?
I needed to do some research because there is more to #temp tables than...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers