What Makes a Good Programmer
Are top notch programming skills innate or can they be learned? Janet Wong takes a look at the skills and capabilities of great programmers in this essay.
XML Workshop XIX - Generating an ATOM 1.0 Feed
Continuing on with his amazing series on XML, SQL Server MVP Jacob Sebastian shows us how to use XML in SQL Server 2005 to generate an ATOM feed.
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
A Worthwhile Goal
Steve Jones talks about two competing priorities for many people that start at a new job and asks which one you value more in this Friday poll.
Finding dependencies in SQL Server 2005
Any time you need to modify objects in your SQL Server 2005 database, the objects that are dependent upon those objects are a concern. You don't want to remove columns from tables, procedures, views, or tables if there are objects dependent upon them that are being used.
Using DDL triggers to audit events
Create DDL table in SQL Server 2005 to audit Data Definition Language (DDL) trigger events when DML statements run. Define DDL trigger to track SQL changes.
Encrypting Data
Encrypting data is the easy part of dealing with encryption and databases. Steve Jones talks about some of the other, more difficult, issues you must handle.
Overview of SSIS
SQL Server Integration Services, the ETL subsystem for SQL Server 2005, is a new paradigm of development for the SQL Server DBA. It is one of the most popular, and also complex, environments that many people work with in SQL Server 2005. Amit Lohia brings us an introduction to this environment along with the basics of building and deploying a package.
The Lighter Side - Life is like an analogy
Longtime SQL Server author and expert David Poole takes a break from SQL Server to bring us a few life lessons for software development.
The SQLServerCentral.com Party - 2008
Steve Jones talks a bit about the upcoming SQLServerCentral.com event at the 2008 PASS Summit and asks for some ideas.
Blogs
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Finding Balance: Things Will Come Up
By Steve Jones
I have a presentation on finding balance in your career that got quite a...
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...
Migrate SSRS Reports to PowerBI Report Server in SQL Server 2025
Comments posted to this topic are about the item Migrate SSRS Reports to PowerBI...
Identities and Sequences III
Comments posted to this topic are about the item Identities and Sequences III
Question of the Day
Identities and Sequences III
When thinking of the Identity property for auto incrementing columns and sequences for the same action, which can be used with the BIGINT data type?
See possible answers