SQL Server User-Defined Functions are good to use in most circumstances, but there just a few questions that rarely get asked on the forums. It's a shame, because the answers to them tend to clear up some ingrained misconceptions about functions that can lead to problems, particularly with locking and performance
2014-06-04
7,408 reads
Lowering the bar for entry does not mean lowering the bar for quality. New to SQL Server? Find out where to start.
2014-06-03
367 reads
This article provides a short PowerShell script to extrace data from a database using PowerShell.
2014-06-03
7,243 reads
In a SSIS data flow, there are multiple types of transformations. On one hand you have synchronous and asynchronous transformations, but on the other hand you have non-blocking, semi-blocking and fully-blocking components. In this tip, Koen Verbeeck takes a closer look on the performance impact of semi-blocking transformations in SSIS.
2014-06-03
2,743 reads
Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data.
2014-06-02
7,056 reads
The way to learn PowerShell is to browse and nibble, rather than to sit down to a formal five-course meal. In his continuing series on PowerShell one-liners, Michael Sorens provides Fast Food for busy professionals who want results quickly and aren't too faddy. Part 3 has as its tasty confections - Collections, Hashtables, arrays and strings.
2014-06-02
4,798 reads
Should you be using Report Builder 3.0 or SQL Server Reporting Services 2008 R2 to build reports? Here's the 411!
2014-05-30 (first published: 2012-03-27)
31,465 reads
Microsoft Azure Queues are a ready-to-use service that loosely connects components or applications through the cloud. This article is the first part in a five-part series about Microsoft Azure Cloud Services by Roman Schacherl.
2014-05-30
2,469 reads
Learn how relationships work in Powerpivot workbooks and how you can build them using the DAX language.
2014-05-29
3,125 reads
After experiencing 'merge misery' personally, Konrad Lukasik came up with 10 well-tested ways of making branches and merges a stress-free part of application development.
2014-05-29
7,273 reads
Do you know if your SQL Server is really running at its best? To...
You can find the slides of my session on the €100 DWH in Azure...
By Steve Jones
This value is something that I still hear today: our best work is done...
Comments posted to this topic are about the item Single User SQL Server on...
Comments posted to this topic are about the item All the Costs of Downtime
Comments posted to this topic are about the item How Well Does the MSSQL...
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers