2012-01-17 (first published: 2010-07-14)
8,963 reads
Articles
Window Functions in SQL Server: Part 3: Questions of Performance
A SQL expression may look elegant on the page but it is only valuable if its performance is good. Do window functions run quicker than their conventional equivalent code? Fabiano Amorim gives a definitive answer.
2012-01-17
4,074 reads
Grant Truncate Table Permissions in SQL Server without ALTER Table
How do you grant a SQL Server developer truncate table permission without giving them the ability to alter the table? Check out the examples and explanation in this tip.
2012-01-16
3,333 reads
Understanding and Using APPLY (Part 2)
The second of a series by Paul White examining the APPLY operator. In this section learn how this operator compares with joins and about both the cross and outer options.
2012-01-13 (first published: 2010-04-19)
29,181 reads
SQL Server Log Shipping to a Different Domain or Workgroup
Sometimes the requirement arises to provide a copy of your database to an off-site location, such as a disaster recovery datacenter. Log Shipping is one of the most popular, proven technologies used to create a copy of your databases on a remote server.
2012-01-13
2,334 reads
ETL Magic with SSIS – Part II
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
2012-01-12
9,621 reads
2012-01-12 (first published: 2010-07-07)
8,796 reads
Grant Fritchey's SQL Server Howlers
We decided to ask various well-known SQL Server people to write about their favorite SQL Server Howlers. These are those common misunderstandings about how SQL Server works that end in tears, and plaintive forum questions. Grant Fritchey opens the series with some of those howlers that stick in the mind.
2012-01-12
4,268 reads
Getting Started with Business Intelligence Semantic Model (BISM) in SQL Server 2012
The Business Intelligence Semantic Model is one of the most significant enhancements in SQL Server 2012. BISM allows aspects of the traditional multidimensional model to coexist with the relational model in a format called the tabular model and can be used with all client tools in the Microsoft BI stack.
2012-01-11
3,322 reads
Dynamically create and populate staging tables from CSV files
This SSIS package reads the first line of a CSV file to obtain field names, then creates a table based on those field names and loads the remaining lines into the table.
2012-01-10
13,871 reads
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers