Check Availability Window - SQL2k5
This script allows you to check the several availability windows for the current day.
2008-01-12 (first published: 2007-10-29)
1,375 reads
Scripts
SMS Script
This script will modify INI file on destops through SMS push to point server connection from A to B.
2008-01-09 (first published: 2007-10-29)
1,310 reads
Script for all Foreign Keys of all tables of a DB
Foreign Keys of all tables in a database? with? table? name? and? column? name??
2008-01-08 (first published: 2006-12-27)
1,054 reads
2008-01-04 (first published: 2007-10-27)
920 reads
Automatically generate SUID procs for any table
This proc generates SELECT, UPDATE, INSERT, and DELETE procs for any given table.
2008-01-02 (first published: 2007-11-08)
1,404 reads
Split by Row & Field delimitters
Like my tdard split but this will take a string and split it by 2 delimiters
2007-12-28 (first published: 2007-11-13)
1,584 reads
2007-12-27 (first published: 2007-10-23)
1,021 reads
Bit Manipulation Functions (4)
Four bit manipulation functions:
1. Turn bit ON
2. Turn bit OFF
3. Check if bit is ON
4. Toggle bit ON/Off
2007-12-25 (first published: 2007-11-01)
1,082 reads
2007-12-21 (first published: 2007-10-25)
1,422 reads
Update Statistics - All Tables (No System)
This proc executing the update statistics command in all user tables (no system).
2007-12-20 (first published: 2007-10-24)
2,376 reads
Blogs
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers