Rebuilding the system databases
The rebuild of the master database (or system databases) on a stand-alone and Failover Clustered (FC) SQL server instance is...
2016-03-02
1,941 reads
Quick Folder Size with PowerShell
This is a fairly simple idea, and one I’m sure many people have done in the past. Personally, I have...
2016-03-02
1,297 reads
Cross-database queries in Azure SQL Database
A limitation with Azure SQL database has been its inability to do cross-database SQL queries. This has changed with the...
2016-03-02
716 reads
How do I grant someone the ability to create a stored procedure?
The question of How to grant the ability to create/alter stored procedures and views came up today on dba.stackexchange.com. It’s...
2016-03-11 (first published: 2016-03-02)
2,329 reads
How to Use Parameters Like a Pro and Boost Performance
Yesterday I presented my favorite session “How to Use Parameters Like a Pro and Boost Performance” in the DBA Fundamentals...
2016-03-01
323 reads
SWITCHing IDENTITY in the Pub
I was recently talking to a friend in our local pub about a problem he had with tables not using IDENTITY...
2016-03-01
675 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
10 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an experience of working with constraints and when I got to...
2016-03-01
10 reads
NULLs to Not NULLs
I have found many columns in many tables of many databases that are defined to allow NULLs but have non NULL...
2016-03-01
110 reads
Find Char nullables to possibly go for not nullables
I often find columns in tables of the databases that are defined to allow NULLs but have non NULL values. That’s actually an...
2016-03-01
119 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Telp BCA KCP Kemang Pratama Cs 0823-7497-7784
Wa:082374977784 Komplek, Ruko Kemang Pratama, Jl. Kemang Pratama Raya No.1A Blk AN, RT.004/RW.001, Bojong...
What Did Healthy Look Like?
Comments posted to this topic are about the item What Did Healthy Look Like?
Alamat BCA KCP Modernland Telp:0821°7555°651
Telp/Wa 628217555651 Ruko Modern Walk, Jl. Hartono Raya No.063 MW No. 062, RT.001/RW.006, Klp....
Question of the Day
DML Trigger Types
How many types of DML triggers are there?
See possible answers