Come see SQLInspireNYC for FREE – Thanks to Red Gate!
SQLInspire, from SQL People, is coming to New York City on Nov. 12, 2011. Win a free admission from Red Gate software to this great event.
2011-10-25
407 reads
Articles
2011-10-25 (first published: 2010-01-06)
11,573 reads
Using TOP To Rank Columns In a Table
This article covers the use of the TOP clause to select data from a table based on the TOP n columns in a table.
2011-10-25
6,564 reads
Using PowerShell for SQL Server Transaction Log Backups
How can I use PowerShell to do a Transaction Log backup for SQL Server databases? In this tip we look at an alternative way of creating transaction log backups using a PowerShell script.
2011-10-25
2,854 reads
Update multiple servers in a single bound
Learn how you can update multiple servers in a single bound with this technique from Kimberly Killian.
2011-10-24
3,957 reads
SQL in the City - LA
Come to SQL in the City, Friday Oct 28, in Los Angeles and meet Grant Fritchey, Brad McGehee and Steve Jones among others. A day of free training for SQL Server professionals.
2011-10-24 (first published: 2011-10-21)
2,347 reads
SQL# (SQLsharp): A Review
Only the brave, and foolhardy, write production CLR routines if you can get the functionality already-written and tested. Whether you’re a DBA or developer, there are plenty of times when a CLR routine will save a lot of time, and occasionally provide new functionality.
2011-10-24
4,490 reads
Diagnosing and Resolving Spinlock Contention on SQL Server
This paper describes how to identify and resolve spinlock contention issues observed when running SQL Server 2008 applications on high concurrency systems with certain workloads.
2011-10-21
2,992 reads
Extract multiple files with a MultiFlatFileConnection data flow task
A data flow task generated by the SSIS Import and Export Wizard can be configured to extract data from multiple files by changing the default connection manager to a MultiFlatFileConnection.
2011-10-20
4,917 reads
Raw Materials - Og, Sumerian DBA
A tale from the days when civilization was young and everything was harder than it is now.
2011-10-20 (first published: 2009-12-30)
10,731 reads
Blogs
T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP
By DataOnWheels
Thanks to everyone who joined the blog party this month. I noticed three themes...
OpenClaw- Agentic Engineering
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Visualising Vectors in High Dimensional Space
Following on from my previous post on building The Burrito Bot, I want to...
Forums
What's new in R 4.6
Comments posted to this topic are about the item What's new in R 4.6
Interesting Changes in R
Comments posted to this topic are about the item Interesting Changes in R, which...
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers