Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties.
For quick and dirty work, sometimes Access is the best way to work with SQL Server. Andy Warren brings a basic tutorial on how you can link Access to your SQL Server tables to easily and quickly manipulate data.
In part 1 of his series on the history of programming, David Chisnall takes a look at some of the developments of the last few decades that have created the current crop of languages and discusses where they came from.
Code profiling tools can help cure most performance problems, but sometimes the problem is so severe that you'll first need to know how to wield computing's least understood tool, the debugger, before diving in with the Profiler. Brian Donahue, Crash Scene Investigator, is on hand to explain why.
In this article, Brian Kelley continues his series on Query Analyzer for SQL Server 2000. Query Analyzer offers a highly configurable integrated development environment (IDE). Some of the areas Brian looks at are how to modify the fonts and colors, set connection settings, choose scripting options, and customizing file and result set options. Learn how to make the most of the IDE and make it work for you.
In this article we are going to see how to change an ADT that is linked to columns with Unique Constraint(s) or Check Constraint(s).
I remember when Windows 3.1 started to gain widespread deployment in businesses. With all it's WYSIWYG features and multiple applications running at the same time, many people felt we'd get to a paperless office. Over a decade later I rarely see an office that doesn't have a copy machine and at least one printer. We've gotten better at shuffling bits, but we haven't gotten rid of paper.
This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.
Mirrored backup commands in SQL Server 2005 work with media sets to minimize data loss. They can also restore a mirrored backup from a different media family.
These 34 subsystems cover the crucial extract, transform and load architecture components required in almost every dimensional data warehouse environment. Understanding the breadth of requirements is the first step to putting an effective architecture in place.
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...
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
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