DBAs and the Fear Factor
Louis Davidson on why DBAs ought to do one thing, every day, that is scary.
Louis Davidson on why DBAs ought to do one thing, every day, that is scary.
Tim Smith describes a number of ways to tell which Stored Procedures are in use, DMVs, a SQL Server Trace, and his preferred method, the Source Code and PowerShell.
We want to make sure we're covering the things that are relevant to you, so we're asking for some feedback on what you use on SSC, where we need to improve, and what you'd like to see.
It should only take a few minutes, and three randomly-selected people will win a $50 Amazon gift card for their efforts.
Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.
Learn the basics of Reporting Services, what it is, and what it can do from you. From MVP Jessica Moss, we have a new series that can help you get started with this part of SQL Server.
Arshad Ali demonstrates granular level encryption in detail and explains how it differs from Transparent Data Encryption (TDE).
Do other departments know what you do? One on one discussions is a great way to make sure.
There were many new DMVs added in SQL Server 2012, and some that have changed since SQL Server 2008 R2. This is a brief overview of the biggest changes and what they mean to you!
SQL Bits is only two weeks away! Join us for the free community day on July 19th, there is also a paid-for pre-conference day on July 17, as well as a paid-for special training day on July 18. There are a whole host of great speakers, including Grant Fritchey, Steve Jones, and David Atkinson (and Brent Ozar, and Benjamin Nevarez, and Karen Lopez...you get the idea). Register while space is available.
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
By Steve Jones
It’s been some time since I provided a car update, so I decided to...
By James Serra
An architecture scenario Imagine separate Sales, Finance, Shared Data, and Executive Analytics workspaces. Sales...
I have a really stupid question... Is there an easy way to search for...
Comments posted to this topic are about the item How to Work with On-Premises...
Comments posted to this topic are about the item 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