SQLBits Friday and Saturday
By David Postlethwaite
The last two days of SQL Bits provide opportunities to hear short 50 minutes presentations from experts
on a...
2011-10-06
711 reads
Gethyn Ellis
SQL Bits Training Day
By David Postlethwaite
Just spent a day with Allen White, a SQL MVP from Ohio, USA learning about automating and managing...
2011-09-29
1,580 reads
David’s SQLBITS Day 1–The Travel Day
Just had a pleasurable 5 hours watching the Autumn countryside go by on a glorious sunny day (in fact its...
2011-09-28
719 reads
Sharon Dooley’s Lightening Talk and the WIT Luncheon
At the end of last week I received an email from my friend and colleague Sharon Dooley telling me her...
2011-08-31
2,516 reads
Using PowerShell to Monitor SQL Server
By Ian Treasure
Over the past few years, I have used a number of approaches to monitor SQL Server. For example,...
2011-08-30
7,256 reads
VMFS LUN resizing options in vSphere
Introduction
First off, many thanks to Gethyn for the opportunity to post on his excellent blog.
I’m Christian Dadswell and I...
2011-08-24
1,837 reads
Get your AD information with .NET
.NET has a useful class called system.DirectoryServices to query LDAP such as Active Directory
Here is some example code to retrieve...
2011-08-22
930 reads
Another New Contributor–Christian Dadswell
This is just a short post to introduce you all to my good friend Christian Dadswell who has kindly agreed...
2011-08-17
858 reads
Auditing SQL Logins Addendum
One thing that has come out of auditing successful logins is the number of applications called ".Net SqlClient Data Provider"....
2011-08-16
761 reads
Auditing SQL Logins Part II
Written by David Postlethwaite
In a previous blog I talked about how to audit successful logins. So what about failed logins?
As...
2011-08-15
1,473 reads
Blogs
Episode 11 of Simple Talks: Oracle
By Steve Jones
The 11th episode is now live, recorded a few weeks ago at the PASS...
A New Word: Mornden
By Steve Jones
mornden – n. the self-container pajama universe shared by two people on a long...
SQL Training: Black Friday Deals Up to 75% Off
This Black Week, don't just get a discount—get ahead! Whether you're a total newbie...
Forums
Blob Storage automated downloads
Dipping my toes into the waters of Azure and of course before I get...
Announcing SQL Server 2025
Comments posted to this topic are about the item Announcing SQL Server 2025
Running Steve's Code
Comments posted to this topic are about the item Running Steve's Code
Question of the Day
Running Steve's Code
Can you run this code in any of your SQL Server 2019 databases without error?
CREATE OR ALTER PROCEDURE [dbo].[StevesAmazingProc]
AS
SELECT Consumer_ID ,
Trend_Category ,
Bit_Trace
FROM NewWorldDB.dbo.MarketTrend;
GO See possible answers