2012-01-31 (first published: 2010-08-11)
9,249 reads
Articles
SQL Server 2008 and 2008 R2 Integration Services - Sampling Transformations
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.
2012-01-31
1,836 reads
SQL Server Log Shipping Between Standalone\Workgroup Computers
This article describes the requirements to log ship databases between workgroup computers
2012-01-30
5,462 reads
Indexing - Take the Hint and Leave it to the Experts
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.
2012-01-30
4,672 reads
Cumulative Aggregates in SQL Server Reporting Services
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.
2012-01-27
2,781 reads
Process Support Database Framework
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.
2012-01-26
3,790 reads
2012-01-26 (first published: 2010-08-04)
9,118 reads
Using XML to pass lists as parameters in SQL Server
Every so often, the question comes up on forums of how to pass a list as a parameter to a SQL procedure or function. Phil Factor provides some examples using XML, and tests them against other popular methods.
2012-01-26
4,027 reads
Controlling Growth of an msdb Database
I recently encountered a situation where the drive hosting Sharepoint Databases in a Staging environment ran out of space. I logged onto the server and found that the msdb database has itself occupied 38 GB of the total disk space. Msdb database generally contain maintenance information for the database such as backups, log shipping and so on.
2012-01-25
2,711 reads
Database Development Tasks Survey
We'd like to better understand the kinds of database related development tasks that you perform, so that we can ensure our tools are helping you to be more productive.
2012-01-25
1,461 reads
Blogs
Webinar: Navigating the Database Landscape in 2026
By Steve Jones
For a number of years, we’ve produced the State of the Database Landscape report,...
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers