Make BOL your friend
One of the most powerful tools we have as users of SQL Server is Books Online (BOL). Whether you work...
2014-06-30
4,056 reads
Kenneth Fisher
Dealing with a long string
Every now and again you have to put a really long string (more than 8000 characters). Dynamic SQL is the...
2014-06-25
2,578 reads
sp_SrvPermissions & sp_DBPermissions V5.0
These are a couple of stored procedures I wrote to help me with security research. Each of the stored procedures...
2014-06-23
689 reads
Aliasing a SQL Server: When it works, when it doesn’t and when it may be your problem.
Creating an alias for a SQL Server is fairly easy and there are several ways to do it. Configuration Manager...
2014-06-20 (first published: 2014-06-18)
2,339 reads
I don’t want to grant permission to all the tables in the database at once.
A couple of weeks ago I did a post on granting or denying permissions to all the tables within a...
2014-06-16
1,166 reads
What is this default trace you speak of?
I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge...
2014-06-12
842 reads
MJ Swart offers free technical editing
A little while back Michael J Swart(B/T) offered to help you become a better writer. This was exciting for me...
2014-06-09
888 reads
Who has the DAC open?
The other day I started seeing the following error in my SQL log.
Error: 17810, Severity: 20, State: 2.
Could not connect...
2014-06-05 (first published: 2014-05-28)
2,633 reads
15 years of experience with Identity columns
An identity column is an auto incrementing columnAn identity column is typically used as a primary keyA primary key that’s...
2014-06-04
1,052 reads
What is the difference between Money and Decimal(19,4)
One of my co-workers and I were discussing the difference between the data type MONEY and the data type DECIMAL(19,4)....
2014-06-02
1,989 reads
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA KCP Buaran Raya Telpon/WA:085188120691
BCA KCP Buaran Raya Telpon/WA:085188120691 Jl. Buaran Raya Blok A No. 100, RT.6/RW.dan 101,...
BCA KCP Pondok Bambu Telpon/WA:085188120691
BCA KCP Pondok Bambu Telpon/WA:085188120691 Pondok Bambu Center, Jl. Pahlawan Revolusi No.30 Blok A/5-6,...
BCA KCP Kramat Jati Telpon/WA:085188120691
BCA KCP Kramat Jati Telpon/WA:085188120691 Jl. Raya Bogor No.19, RT.1/RW.4, Wil, Kec. Kramat jati,...
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers