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
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,054 reads
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
Part II of a discussion and demonstration of ETL of a CSV data file using SSIS.
2012-01-12
9,619 reads
2012-01-12 (first published: 2010-07-07)
8,794 reads
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
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
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,858 reads
Leibniz breaks out of a buyer's dilemma that might defeat a subtler mind.
2012-01-10 (first published: 2010-06-30)
9,240 reads
Rob Sullivan is one of the users who are helping shape the way that SQL Test develops, and here he explains what is going on, and why.
2012-01-10
1,883 reads
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
By Steve Jones
It was neat to stumble on this in the book, a piece by me,...
Forgive me for the title. Mentally I’m 12. When I started my current day...
Comments posted to this topic are about the item Microsoft Security Changes and SQL...
Comments posted to this topic are about the item Expanding into Print
Comments posted to this topic are about the item Downtime Caused by the Postgres...
In SQL Server 2025, what is returned by this code:
SELECT EDIT_DISTANCE('Steve', 'Stan')
Assume preview features are enabled. See possible answers