An introduction to the SQL Trace catalog views and functions used to view existing trace definitions targeted at DBAs and Developers. The article discusses T-SQL queries to view defined traces, query trace status and start/stop/delete traces.
This white paper explains how Microsoft® adCenter implemented a Microsoft SQL Server® 2008 Analysis Services Scalable Shared Database on EMC® Symmetrix VMAX™ storage. Leveraging TimeFinder® clones and Enterprise Flash Drives with the read-only feature of SQL Server 2008 Analysis Services allowed adCenter to dramatically scale out OLAP while maintaining SLAs and decreasing system outages.
A free one day training event in Columbus, OH on Jun 11, 2011. Come join us and learn about SQL Server.
This article will explain different types of visualizations, including charts and maps, and when you would use each type.
Today we have an editorial from Mar 22, 2006 as Steve is on vacation. Today Steve Jones notes that economics might determine how you are paid, but human nature describes how you behave.
Digitization transforms yet another of our most cherished traditions.
I'm trying to set up SQL Server and I know that I'm not supposed to use an account that's an administrator on the system, as per best practices. I see that the System account is a possibility, but I've been advised not to use it. Why not? Check out this tip to learn more.
Today we have an editorial reprinted from April 3, 2006 as Steve is on vacation. Ethics are often just as bad at the top of our companies as they are at the bottom. Steve Jones comments today on how this affects IT.
This week Steve Jones looks at a few notes that show employers are wising up overall about certifications and the value of real world skills.
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
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