Row Sampling Transformation and Percentage Sampling Transformation provide data sampling functionality. This functionality is useful in a number of Analysis Services and Data Mining-based scenarios.
Would any of you want to track your morale at work and have your boss access the data anonymously? Steve Jones think it's a good tool, but one that is easily abused.
This article describes the requirements to log ship databases between workgroup computers
The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.
Today we have a guest editorial from Andy Warren. Today Andy suggests you try some new tools and see if you can increase your productivity.
In this tip, we will see how to build a report which shows the cumulative sales amount for the current month, current quarter (QTD) and current year (YTD) in a single crosstab (tablix) report, which makes it easy to compare the data.
Today Steve Jones talks a little about the work environment for IT workers. We ought to pay attention and ensure we are taking care of ourselves.
Do you use or need a database process framework? Read on to see if this is something that might help you build better database software processes.
Thank you to everyone who participated in T-SQL Tuesday #198! When I wrote the...
Efficient query performance in Amazon Redshift often comes down to how well you manage...
By gbargsley
Welcome back to PowerShell Strikes Back. We’re three weeks in, and the training is...
Comments posted to this topic are about the item Stairway to Reliable Database Deployment...
Comments posted to this topic are about the item QUOTENAME Quote Parameters
Comments posted to this topic are about the item Limit the Blast Radius
When I use QUOTENAME(), I can optionally provide the character used to surround the string in the result. Can I use any character?
See possible answers