Use the 4th Dimension
Today Steve Jones talks about the conflicting demands of home and work and how you can reconcile the requirements of both.
Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
In this tip we cover what CONTROL SERVER is, how to detect its use and a possible way to exploit this permission.
Insert, Update, and Delete Indexes: Stairway to SQL Server Indexes Level 13
What happens to your indexes during normal database activity?
The Cloud is good for your career
Is the cloud good for your career? Steve Jones thinks so, and gives you a few reasons you might want to learn more about it.
New User-defined Server Roles in SQL Server 2012
SQL Server 2012 brings new security enhancements, one of which is to create user defined server roles, which simplifies instance wide administration and helps to increase the security of the instance by letting you define different groups with different sets of permissions as per their role and responsibilities.
Configuring Service Account Privileges for SQL Server
How to grant Windows privileges to the SQL Server's service account.
Taking a Sabbatical
Today we have a guest editorial from Andy Warren as Steve is on vacation. Today Andy discusses sabbaticals, and a change in his life.
Automated Script-generation with Powershell and SMO
Phil Factor demonstrates how to generate T-SQL scripts for databases, selected database objects, or table contents from PowerShell and SMO.
Call That a Database? This is a Database.
If only the English language had a range of words to describe all the different types of database, there would be so much less confusion in the industry.
Blogs
Overcoming Imposter Syndrome: A Plan
By Brian Kelley
My most recent bout with imposter syndrome was with ISACA’s Digital Trust Ecosystem Framework...
Advice I Like: Celebrate Success
By Steve Jones
“On the way to a grand goal, celebrate the smallest victories as if each...
Programmatically Retrieving MLV Lineage and Refresh Times
Materialized lake views (MLVs) in Microsoft Fabric are an effective way to implement medallion...
Forums
BCA Finance Tangerang Layanan Mobil Telpon/WA:085188120691
BCA Finance Tangerang Layanan Mobil Telpon/WA:085188120691 Scientia Garden, Jl. Gading Serpong Boulevard No.1 Blok...
BCA KCU HARAPAN INDAH Telpon/WA:085188120691
BCA KCU HARAPAN INDAH Telpon/WA:085188120691 Jl. Sentra Niaga Jl. Harapan Indah Boulevard Kav. CP2...
BCA MULTI FINANCE CAB SUNTER Telpon/WA:085188120691
BCA MULTI FINANCE CAB SUNTER Telpon/WA:085188120691 Ruko Danau Sunter Utara, BLK. a 36D Jl....
Question of the Day
Increase Deadlock Detection
How can I alter the deadlock detection interval to 2 seconds instead of 5 seconds on my SQL Server 2025 instance?
See possible answers