Visualize Tech Skills
Is your area of responsibility starved for resources? Is it difficult to get a raise? If so, don't despair. You're...
2011-02-24
1,830 reads
Configuring Antivirus for SQL Servers
I've been on both sides of the debate with respect to whether or not to install antivirus software on a...
2011-02-24
3,389 reads
SQLskills Immersion Event on Internals and Performance – Day 3
Overview
Today was mostly about Table Design, Partitioning, with a little of Indexing. Partitioning is a big, complex topics with a...
2011-02-24
479 reads
How Can I Help You Go To SQLRally?
I bet by now you've heard of SQLRally, be it from the blogosphere, Twitter, the PASS Connector bi-weekly emails, word...
2011-02-23
406 reads
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I explained this in Post 6 of PowerShell Week at...
2011-02-23
17 reads
Emailing tempdb Query Results to Paul Randal with PowerShell
I was referred to someone on twitter today who wants to email query results without setting up database mail. I...
2011-02-23
1,951 reads
Fundamentals of Storage Systems, IO Latency and SQL Server
A Thousand Men Marching Still Only March As Fast As One Man.
la·ten·cy - Computers . the time required to locate the first bit or character in a storage location, expressed as access timeminus word time.
Often when talking to people...
2011-02-23
3,095 reads
You Can’t Disable the CLR in SQL Server – MCM Prep
At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even...
2011-02-23
933 reads
Who’s My Agent?
Alright, I’m not famous, even though I share the name of a famous Jazz pianist. So, obviously I am NOT...
2011-02-23
713 reads
FileSystemHelper Update and Release
About a year ago, I started playing around with CLR and my desire to disable xp_cmdshell for my clients. As...
2011-02-23
488 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