2018-01-23 (first published: 2009-10-27)
15,686 reads
Scripts
Database maintenance progress
Often we need to know on which stage is a maintenance operation such as: backup, restore, check database. You can get this information using my script.
2018-01-17 (first published: 2018-01-12)
648 reads
Difference between dates displayed in days, hours, minutes and seconds
Show the difference between two dates (from, to) in format #d HH: MM: SS
2018-01-03 (first published: 2017-12-18)
504 reads
Powershell Script for regular DBA activities_GenerateScripts
Powershell utility for
generating scripts for db tables with / without identity columns.It can also produce scripts for fixed number of rows
2018-01-02 (first published: 2017-12-18)
1,186 reads
2017-12-29 (first published: 2017-12-27)
1,686 reads
Trigger Based Change Data capture
This script capture INSERTs / UPDATEs / DELETEs on SQL Server table and logs to single table in JSON Format.
2017-12-22 (first published: 2017-12-01)
2,993 reads
Real World: SQL Server Quick Quality Check
Here is a script that can give the DBA a SQL Instance quick quality check.
2017-12-21 (first published: 2015-01-02)
7,100 reads
Read Only access to all databases to a user in a SQL Server Instance
Script to grant a SQL a user read-only access to all the databases in Server instance except the system databases and
-- the Log shipped databases(if any : secondary :read-only)
2017-11-22 (first published: 2017-11-14)
23,681 reads
Reporting by date - DateTrunc
A function to truncate datetimes to month, quarter, hour etc and their multiples for convenient grouping
2017-11-21 (first published: 2017-11-14)
629 reads
Dynamic SQL procedure for bulk insert
https://github.com/ktaranov/sqlserver-kit/blob/master/Stored_Procedure/usp_BulkUpload.sql
2017-11-17 (first published: 2015-05-16)
5,268 reads
Blogs
Reading Blogs: T-SQL Tuesday #204
By Steve Jones
This is an interesting invitation this month. Jeff Ianucci is a new host, and...
Are Blogs Still Relevant? - T-SQL Tuesday #204
By alevyinroc
T-SQL Tuesday is a monthly blog party hosted by a different community member each...
How I Built RAG for My Accounting App on Bedrock and pgvector
The first version of my accounting assistant could not find a single purchase of...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Slow - Linked server query
Hi I have this slow query that is pulling data from a linked server....
Too Many Choices
Comments posted to this topic are about the item Too Many Choices
Question of the Day
Too Many Choices
I have a table, dbo.MasterBrands, with this data:
BrandID OfficialName 1 Samsung 2 Apple 3 Microsoft 4 Adidas 5 Coca-ColaI run this query. What is returned for Coca-Cola?
SELECT CHOOSE(BrandID, 'Conglomerate', 'Tech and Design', 'Desktop', 'Apparel') FROM dbo.MasterBrands;See possible answers