Generate Login Script(2008R2 And Older)
Generate Script from Logins of Sql Server to recreate in another instance
2015-08-25 (first published: 2015-08-10)
1,781 reads
Scripts
Cleanup Older than 30 days of Files & Folder through SQL Job
Using Powershell, Cleanup Older than 30 days of Files & Folder through SQL Job
2015-08-24 (first published: 2015-08-04)
2,663 reads
Query to Delete all Folders, Sub-Folders and Files located in a Path
A script to help you cleanup Files/Folders & Sub-folders.
2015-08-20 (first published: 2015-07-30)
89 reads
Filestream and FileTable Implementation SQL Server 2012.
In this article, I would like to demonstrate about Filestream and FileTable implementation in SQL Server 2012.
2015-08-19 (first published: 2015-07-24)
1,632 reads
SQL to APS Automation
This script was designed to help make importing data from any SQL2008+ database to an APS much easier.
2015-08-12 (first published: 2015-07-14)
1,154 reads
2015-08-10 (first published: 2015-07-16)
1,613 reads
List Out All User Defined Triggers
List Out All User Defined Triggers, along with the database where the triggers are disabled. is_ms_shipped = 1 denotes that its an user written trigger.
2015-08-06 (first published: 2015-07-07)
865 reads
Kill all USer Sessions before starting to restore a Database
If you have a requirement to Kill all USer Sessions before starting to restore a Database, you may use this script
2015-08-05 (first published: 2015-07-08)
2,168 reads
2015-08-04 (first published: 2015-07-08)
732 reads
2015-08-03 (first published: 2015-07-12)
1,389 reads
Blogs
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...
Why AI isn’t paying off yet, and what to invest in first
Why isn’t AI paying off yet? Drawing on lessons from digital transformation, Joyful Craftsmen...
Flyway Tips: Analytics Platforms (Snowflake and Databricks)
By Steve Jones
I’m really excited about some growth in Flyway support. I’ve been asking about this...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Layanan BCA KCU JOMBANG Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. KH. Wahid Hasyim No.20, Jombang, Kec. Jombang, Kabupaten Jombang, Jawa Timur 61415
Layanan BCA KCP Pemalang Hub/Wa. 0817-819-444
WhatsApp:0817819444 Jl. Jend. Sudirman No.6, Mulyoharjo, Kec. Pemalang, Kabupaten Pemalang, Jawa Tengah 52313
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