We recently had an application login (SQL Server authenticated) in one of our training environments start locking out on a ... Continue reading
2021-08-09 (first published: 2021-07-22)
808 reads
I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to ... Continue reading
2021-08-02 (first published: 2021-07-15)
405 reads
It’s a SQL Server Instance not a SQL Server. The product is SQL Server. The installed copy is an Instance. ... Continue reading
2021-07-29
343 reads
I don’t speak all that often. A few times a year for the most part. Because of that I don’t ... Continue reading
2021-07-27
13 reads
Thanks for agreeing to do this Kellyn. I’ve always found you to be one of the more interesting personalities in ... Continue reading
2021-07-23 (first published: 2021-07-08)
245 reads
Hypothesis: If I have Dynamic Data Masking enabled on a column then when I use something like BCP to pull ... Continue reading
2021-07-20
11 reads
This is a quick non-technical discussion (i.e. not a how to in any way) of some of the benefits of ... Continue reading
2021-07-16 (first published: 2021-06-29)
675 reads
I was speaking with one of my favorite people in the SQL Server community, Grant Fritchey (blog|twitter), on twitter today. ... Continue reading
2021-07-06
89 reads
In my last post I talked about reasons why your permissions might go missing. One of the reasons, and in ... Continue reading
2021-07-05 (first published: 2021-06-24)
234 reads
Log shipping is probably the least complicated and easiest to configure of the various methods of creating a secondary copy ... Continue reading
2021-07-01
29 reads
By Zikato
TSQL ScriptDOM is a useful library for parsing scripts into an abstract syntax tree....
By DataOnWheels
Over the past few months, I have debated starting a new blog to discuss...
By Steve Jones
It’s that time of the month again, and once again, I’m late and I’m...
So folks we have around 30/40 sql server failover cluster insatnce with each having...
Hello, How to add a UNIX_TIMESTAMP at my publish_date please CREATE TABLE [dbo].[latest_info]( [id]...
hi, need to known weather fast farwand cursor is faster than a while loop...
I run this code on SQL Server 2022 to get a list of all the indexes and their key columns. What is returned?
SELECT
INDEX_COL (N'AdventureWorks2017.Sales.SalesOrderDetail') See possible answers