Give and Take
This Friday Steve Jones asks about capital at work and does it affect the way you do business.
2008-02-21
36 reads
Articles
Storing Images and BLOB files in SQL Server Part 2
Part two of this article focuses on using the SQL Server Binary data type to store small image files.
2008-02-21
3,478 reads
The Stewardship Approach to Data Governance: Ch. 6
This is the sixth article in a continuing series, and this installment discusses the establishment and role of a Data Governance Council.
2008-02-21
1,328 reads
Securing the SA Account in SQL Server 2005
SQL Server 2005 has greatly changed the security paradigm for SQL Server DBAs. The sa account still exists, but for many tasks
you can now avoid using it. New author Ken Johnson brings us some ides for properly securing this highly privileged account.
2008-02-20 (first published: 2007-03-14)
16,605 reads
New Data Types in SQL Server 2008 Part 2
In this article, we are going to explore the new HierarchyID data type. We are going to show how to implement hierarchies in SQL Server 2005 and than how same thing in can be achived in SQL Server 2008 using the HierarchyID data type.
2008-02-20
4,301 reads
Add Custom XML Documentation Capability To Your SQL Code
By adding XML-based documentation capability to your SQL code, you can automatically extract and format tagged comments into a complete API documentation set for your SQL libraries.
2008-02-20
2,980 reads
2008-02-20
29 reads
2008-02-20
37 reads
2008-02-20
47 reads
5 Tips for Becoming a Better Data Modeler
5 quick tips to help you become a better data modeler and increase your value to your team and organization.
2008-02-19
12,033 reads
Blogs
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...
Why your data still can’t answer a simple question
Every organization I talk to has the same problem dressed up in different clothes....
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...
Creating a Simple and Flexible Random Password Generator in SQL Server
Comments posted to this topic are about the item Creating a Simple and Flexible...
SQL Art, Part 3: Happy Easter Fun in SSMS
Comments posted to this topic are about the item SQL Art, Part 3: Happy...
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