Finding a Mentor
Someone asked Steve Jones about finding a mentor to become a better DBA. He shares some thoughts and advice about how to do this.
Getting started with SQL Server database diagrams
In this tip I show you how you can use the built-in SQL Server database diagram tool. I go through some of them messages you may get when getting started and then look at various tasks that you would perform using this free tool.
SQL Bits
The next SQLBits conference is being held Nov 19-21, 2009 in Newport, UK. If you want to attend or even speak, read more about this event.
Moving Databases with the ALTER Command
A script that will move the files of a passed set of databases to a new data folder and log folder from James DiMauro.
A True SQL OS
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
A True SQL OS
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
A True SQL OS
SQL Server is so large and complex that it's like an operating system. In fact, there the core engine is often referred to as the "SQL OS" by Microsoft developers. Steve Jones would like to see SQL Server as it's own OS at some point.
Kimball University: Five Alternatives for Better Employee Dimension Modeling
The employee dimension presents one of the trickier challenges in data warehouse modeling. These five approaches ease the complication of designing and maintaining a 'Reports To' hierarchy for ever-changing reporting relationships and organizational structures.
SQL Server Security Audit (Part 1) - Server Level Audit
The first of this three part series on SQL Server Security Auditing focuses on the SQL Server itself and addressing any of its security vulnerabilities.
Overselling Yourself
Posting online is a way of building your own brand, but you need to be careful of overselling yourself. Steve Jones talks about being careful in the impressions you create from your online presence.
Blogs
KDA: Echoes of Deception - Case 6
By Zikato
A cryptic message, a book cipher hidden in art provenance records, and a trail...
Capturing My Own Metrics: #SQLNewBlogger
By Steve Jones
A customer was trying to compare two tables and capture a state as a...
Red Flags in Your Query (T-SQL Tuesday #200)
By Zikato
When I'm looking at a query, I bet it's bad if I see... a...
Forums
Alamat Kantor BCA KCU PONTIANAK Telp:082144477715
WA:0821-4447-7715 Jl. Jenderal Ahmad Yani No.1, Benua Melayu Darat, Kec. Pontianak Sel., Kota Pontianak,...
ALAMAT BCA KCU DAAN MOGOT Telp:08218200205
WhatsApp:08218200205 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Alamat Kantor BCA KCU DAAN MOGOT Telp:0817781222
WA:08218154393 Jl. Daan Mogot No.95, RT.5/RW.3, Wijaya Kusuma, Kec. Grogol petamburan, Kota Jakarta Barat,...
Question of the Day
Checking the Error Log I
On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?
See possible answers