Three Attack Vectors in SQL Server 2005
This article outlines three different tried and tested methods of obtaining access to databases in SQL Server 2005 where no database-level administrative access exists.
2012-03-07
7,427 reads
Articles
SQL Server 2012 - The Virtual Launch Event
Microsoft has scheduled a virtual launch event for SQL Server 2012 on Mar 7. Register now to learn about the next version of SQL Server.
2012-03-07 (first published: 2012-03-01)
4,718 reads
Large table cleanup with minimal locks
How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.
2012-03-06
15,497 reads
SQL Saturday #114 - Vancouver
A free day of SQL Server training in Vancouver, BC, Canada on Mar 17, 2012.
2012-03-06
1,373 reads
SQL Saturday #115 - Portugal
A free day of SQL Server training in Lisbon. Register and come if you can.
2012-03-06
1,289 reads
TSQL Challenge 77-Transform monthly resource efforts to weekly actuals
The challenge is to transform monthly resource efforts into weekly actuals.
2012-03-05
735 reads
Working with Perfmon CSV logs in Powershell
When all you have is Powershell and perfmon logs, here's a way you can use them together to perform some analysis.
2012-03-05
4,144 reads
2012-03-05
1,402 reads
The Road to Professional Database Development: Set-Based Thinking
Under the pseudonym of 'SwePeso', Peter Larsson is famous on SQL forums for the amazing performance he can get from SQL. How does he do it? In the first of a series of articles, Peter explains his secrets.
2012-03-05
4,317 reads
Eliminating Duplicate Rows using The PARTITION BY clause
The Partition clause in the Row_Number() Over() function is a quick tool for eliminating duplicate rows.
2012-03-02 (first published: 2010-09-22)
144,168 reads
Blogs
The end of an era – why I chose not to renew my MVP
By DataOnWheels
Two years ago, two things happened within a few days of each other. I...
PowerShell Strikes Back: A New Script
By gbargsley
This is it. The final chapter of PowerShell Strikes Back. Over the past four...
Claude Desktop
By Arun Sirpal
Claude is more than a chat window. The desktop experience includes structured workspaces, generated...
Forums
Unraveling the Mysteries of the Ephemeral Model: The Fabric Modern Data Platform
Comments posted to this topic are about the item Unraveling the Mysteries of the...
QUOTENAME Behavior
Comments posted to this topic are about the item QUOTENAME Behavior
Running script without having permission to Function
Good Morning. I have a T-SQL Script which has been developed to execute a...
Question of the Day
QUOTENAME Behavior
I use QUOTENAME() like this in code?
DECLARE @s VARCHAR(20) = 'Steve Jones' SELECT QUOTENAME(@s, '>')What is returned? See possible answers