Who did what to my database and when…
One of the most popular questions on forums / SO etc is, “How can i find out who dropped a table,...
2016-08-30 (first published: 2016-08-22)
2,820 reads
Dave Ballantyne
Why is creating excel sheets from SSIS so hard ?
If there is one process that should be simpler than it is out of the box, it is creating Excel...
2016-06-17
1,429 reads
.Net 4.6.1 and MultiSubnetFailover
Im not a big clustering/HA expert, but I obviously understand the need for such things to exist
However, the standard...
2016-03-24
1,197 reads
A journey to a movie recommender in U-SQL
I haven’t gotten to involved in the whole “Big Data” movement to much, I’ve kept an arms length watch and...
2016-03-23 (first published: 2016-03-20)
1,863 reads
A first look at SQL Server 2016–String_split
I’ve been developing T-SQL for about 20 years now and almost since day one there has been functionality that , IMO,...
2016-03-13
594 reads
My favourite wait state– ASYNC_NETWORK_IO
Sometimes it does feel that a problem is a database problem until proven otherwise. When this does occur I have...
2016-03-03 (first published: 2016-02-28)
2,821 reads
SQL Saturday 496 Exeter – PreCon Agenda
Hi
Unfortunately due to matters outside of my control, SQL Saturday 502 in Edinburgh has been cancelled, I would like...
2016-02-14
484 reads
SQL From South West to Scotland : SQLSaturdays #496 & #502
I’m happy, honoured and humbled to be able to say that I will be presenting pre-cons and both SQL Saturday...
2016-01-17
394 reads
A first look at Redgate Reference Data Manager
Over the past few years one of the big drives and innovations in the SQL Server world, has been to bring...
2016-01-05
425 reads
SQL Saturday 467 - Precon - Query processing and internals
Im not doing a tremendous amount of public speaking this year and concentrating on more professional matters, however im pleased...
2015-10-04
456 reads
Blogs
How to: Regain SysAdmin Access to a SQL Server Instance Without the SA Password
By gbargsley
Hello, reader! Today, I’m going to walk you through a scenario that many DBAs...
Secure Your SQL Estate: Best Practices for Azure SQL Security
By Chris Yates
The Castle and the Keys Imagine your Azure SQL environment as a sprawling digital...
The Book of Redgate: Meetings
By Steve Jones
I think we might have forgotten this a bit, but on one of the...
Forums
The Duplicate Cursor
Comments posted to this topic are about the item The Duplicate Cursor
Concerns over AI Chat Privacy
Comments posted to this topic are about the item Concerns over AI Chat Privacy
Introduction of Azure SQL Hyperscale: Stairway to Azure SQL Hyperscale Level 1
Comments posted to this topic are about the item Introduction of Azure SQL Hyperscale:...
Question of the Day
The Duplicate Cursor
Can I run this code:
DECLARE ANewTable CURSOR FOR SELECT * FROM ANewTableSee possible answers