2010-09-29 (first published: 2010-09-28)
1,636 reads
Scripts
After Restoring MSDB perform the following two steps
This script has two essential Steps after restoring MSDB
2010-09-21 (first published: 2010-09-20)
2,340 reads
Way to Check Multiple LIKE without dynamic SQL
I was asked to do so by one of my colleague. So, I thought to share it with you how to use multiple LIKE conditions.
2010-09-16 (first published: 2010-09-15)
3,801 reads
Retreive the Schema of a Stored Procedure or Function
This script shows you code that retrives schema of a routine (Stored procedure or a function).
2010-09-09 (first published: 2010-09-04)
1,992 reads
2010-09-08 (first published: 2010-09-02)
2,374 reads
Just for fun
Do you need to take your mind off of the SQL mess you are dealing with? Try my funny words generator.
2010-09-03 (first published: 2010-08-27)
2,668 reads
Change the collation of Columns
This script changes the collation of columns to default database collation in all the tables
2010-09-02 (first published: 2010-09-01)
2,189 reads
Windows Group Membership Checker
A script to reveal which logins have access to your sql server via windows groups.
2010-09-01 (first published: 2010-08-26)
2,440 reads
Make string columns unicode compliant
Generates scripts to make text, ntext, varchar and char columns nvarchar/nchar
2010-08-30 (first published: 2010-08-26)
1,331 reads
2010-08-27 (first published: 2010-08-25)
3,693 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
Alamat BCA KCP Dewi Sartika Tlp:08218200233
Telp/WA 62 8218200233 Jl. Dewi Sartika No.189, RT.1/RW.5, Wil, Kec. Kramat jati, Kota Jakarta...
Alamat Kantor BCA KCP MT Haryono Tlp:08218200203
Telp/WA 62 8218200203 Gedung Patria Park Jl. D.I. Panjaitan Kav. 5-6-7, Rukan-MZ No.RK 01...
Alamat BCA KCP Pondok Gede Tlp:08218200174
Telp/WA 62 8218200174 Jl. Raya Pd. Gede No.43, RT.1/RW.7, Lubang Buaya, Kec. Cipayung, Kota...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers