Does your organization need a DBA? (part 2)
This is a follow-on to Does your organization need a DBA? and Andy Leonard's Database Professionals: An Enterprise Requirement.
I was...
2006-08-01
688 reads
Brian Kelley
- Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology
Does your organization need a DBA?
Andy Leonard pens the following blog entry:
Database Professionals: An Enterprise Requirement
There are quite a few organizations that feel they can...
2006-07-30
1,530 reads
Succint Article on Encypting File System (EFS)
Encrypting File System, or EFS, first debuted in Windows 2000 and gave
users to encrypt files without a 3rd party tool....
2006-07-30
1,576 reads
Detecting SQL Server 2005 Properly
There is a new post in the SQL Server Express blog which indicates the
right way to detect SQL Server 2005:...
2006-07-29
1,468 reads
More SQL Server blogs
There is a new site for SQL Server blogs, SQLBlog.com. "Brought to you by Peter DeBetta & Adam Machanic," it has...
2006-07-29
1,311 reads
New Windows Vista Security Blog
If you're keeping up with Windows Vista and you're interested in the
security aspects of it, there's a new blog, with...
2006-07-29
1,382 reads
Connecting With Perl Using Win32 : ODBC
Perl has been a popular language for Unix administrators for years. It is flexible, easy to learn, and capable of doing some very powerful things with relatively few lines of code. In this article by Brian Kelly, he shows you how to connect to SQL Server via Perl.
2006-07-28 (first published: 2002-12-03)
41,929 reads
Haidong Ji blogs on a tip for learning Perl
Haidong Ji, co-author of Professional SQL Server 2005 Integration Services, blogged on Learning Perl using the Perl Debugger. Haidong posts...
2006-07-27
1,589 reads
Interview with Craig Mundie on Channel 9
Channel 9 has posted a 25 minute interview with Craig Mundie, Chief Research and Strategy Officer for Microsoft. You can...
2006-07-27
1,646 reads
New SQL Server 2005 Books Online download available
As reported in several other places... there is a new Books Online (July 2006) for SQL Server 2005. You can...
2006-07-25
1,892 reads
Blogs
6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
Data-driven vs. Data-informed: Let’s Acknowledge the Truth
This comic was retweeted into my timeline on Twitter (I refuse to call it...
Writing Parquet Files – #SQLNewBlogger
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
Forums
Can you connect Power Apps to SQL Server if you work in the government?
My agency has been using the combo of on-premises SQL Server for the back...
Unable to connect to SQL 2019 using Pyodbc
Development Environment I am learning how to use pyodbc and accessing database in SQL...
Multiple deadlocks occurring with contentious code
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
Question of the Day
Multiple Query Trace Flags
I want to enable two trace flags, 4199 and 4137, for a single query. How should I do this:
-- A
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, 4137);
-- B
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199, QUERYTRACEON 4137);
-- C
SELECT
a.AddressID
, a.AddressLine1
, a.AddressLine2
, a.City
, a.StateProvinceID
, a.PostalCode
, p.FirstName
, p.LastName
FROM
Person.Address a
INNER JOIN person.Person AS p
ON p.rowguid = a.rowguid
WHERE
City = 'SEATTLE'
AND PostalCode = 98104
OPTION (QUERYTRACEON 4199), (QUERYTRACEON 4137);
See possible answers