SQL Server Default Trace
The default trace in SQL Server is something I have been experimenting with lately. It is a feature included in...
2010-02-04
3,868 reads
Gethyn Ellis
“Building a Better Blog” with Steve Jones
I recently watched Steve Jones’ (Blog | Twitter) "Building a better blog" presentation from the 24 hours of PASS virtual conference...
2010-02-02
841 reads
Professional Association of SQL Server (PASS)
I recently discovered the Professional Association of SQL Server (PASS) virtual chapters. For those of you who struggle to make...
2010-01-31
2,023 reads
SEO my SQL Server Blog
I was going to spend today finishing off some SQL Server related blog posts, I currently have a list of...
2010-01-30
1,645 reads
Wildcards in WHERE Clauses
This is just a very short post regarding the use of wildcards in a WHERE Clause
It is possible that the...
2010-01-27
586 reads
XML Index - ALTER INDEX with REBUILD Issue
I run into a small issue at the end last week, a CHECKDB job was reporting corruption on one of...
2010-01-24
657 reads
Instant File Initialisation
I have been reading up on instant file initialization and I have read a couple of good blog posts by...
2010-01-21
1,405 reads
DDL Triggers
We had a request from a developer who wanted to access data from a source database and another database on...
2010-01-20
1,003 reads
SQL Server 2008 R2 - Release May2010
SQL Server 2008 R2 now has a release date...May 2010.
Check out the microsoft site for more details...link to follow
2010-01-20
551 reads
SQL Server Resource Governor
I didn’t know this bit Resource Governor in SQL Server 2008 is only available in Enterprise edition
2010-01-20
1,082 reads
Blogs
Github Copilot in SSMS can include data in its memory, simple prompt injections ahead
By Ed Elliott
SQL Server Management Studio (SSMS) has recently added support for Github Copilot. This is...
Advice I Like: Failure
By Steve Jones
If it fails where you thought it would fail that is not a failure....
Logged in as a member of an Azure AD Group Error while Deploying DACPAC
Quite a long title for a short blog post ??While deploying a DACPAC (from...
Forums
A Place where AI Technology Shines
Comments posted to this topic are about the item A Place where AI Technology...
Question of the Day
Getting the Object Code
What happens when I run this on SQL Server 2022 in the AdventureWorks2022 database?
SELECT OBJECT_DEFINITION (OBJECT_ID(N'dbo.uspGetBillofMaterials')) AS [Object Definition]; GOSee possible answers