Building a Security Philosophy
SQL Server trainer and expert DBA, Andy Warren, thinks that everyone should have a philosophy about security. He starts this installment in looking about how to assign administrative privileges.
SQL Profanities
Do you avoid certain SQL functionality because you have been told you should NEVER use it?
A Strategy to Determine the Size and Cost of Database-Centric Business Information Systems
This paper presents an approach to the definition of function points within database-centric business information systems, the process of counting function points, .
Index Metadata and Statistics Update Date for SQL Server
Statistics update date is stored as metadata on the SQL instance, but after a great deal of research against the system tables and DMVs I realized that this information is not readily exposed to the DBA via any other method than the STATS_DATE() function or the SQL Server Management Studio graphical user interface (GUI).
Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
Snooping
System administrators have a lot of power and temptation to use it. Steve Jones talks about the need to resist temptation and the need for oversight.
Bill Baker - Database Weekly (Aug 11, 2008)
This weeks Database Weekly looks at a longtime leader for the Microsoft SQL Server development team leaving the company.
The Starting Point
The Mojave Experiment is a marketing effort by Microsoft that is very interesting in looking at first impressions. Steve Jones comments.
Uncommon Table Expressions
This article describes an alternate use of CTEs for functional data processing.
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers