Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
1,694 reads
Steve Jones asks today if you have any architectural principles at your job that you use to build software. Having a set of guidelines is a great way to build better software and having your own set of principles will help you to build better software as well.
2009-12-17
3,464 reads
Tally (or numbers) tables are one of my favorite query writing tools. Such a simple premise that can be applied...
2009-12-17
3,185 reads
SQLDIAG or PSSDIAG are excellent tools used to collect and analyze data in order to identify possible performance root causes. The issue is that the output produced by such utilities is sometimes convoluted, hard to read and hard to understand. In this tip, I will show you a tool that you can use to read and analyze the data collected by these tools.
2009-12-17
2,873 reads
Keeping track of the space used and free in your database files is something that all experienced DBAs need to do. And something many new DBAs forget. New author Jayakumar Krishnan brings us an easy technique to do this in SQL Server 2008 with Policy Based Management.
2009-12-16
8,506 reads
BI Architect Bill Pearson continues his discussion of Partition planning for Analysis Services, this time focusing on the settings and properties involved from a SQL Server Management Studio perspective.
2009-12-16
2,465 reads
The size of databases have been growing in such a way, it sometimes is hard to have a single drive / tape to...
2009-12-16
2,636 reads
Provides Stored Procedures and SSRS Report to show job status with details of errors.
2009-12-15
9,548 reads
In previous articles, we have covered the system bus, host bus adapters, and disk drives. Now we will move up...
2009-12-15
4,053 reads
A well run company will help you keep your purpose at work in mind. However many companies don't do a good job here and Steve Jones laments the lack of leadership in many companies.
2009-12-15
1,779 reads
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
Comments posted to this topic are about the item The day-to-day pressures of a...
Comments posted to this topic are about the item The Problem Isn't Always Your...
Comments posted to this topic are about the item Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers