In this Webinar on Tuesday September 12, Louis Davidson will explain the differences between good and bad database design. He'll discuss characteristics such as comprehendible, documented, secure, well performing, and normalized (naturally). Register to come along.
2013-09-11
4,032 reads
PASS Professional Development Virtual Chapter will be hosting a session on what managers need to know about SQL Licensing, presented by Joseph D'Antonio on September 11, 2013.
2013-09-06
3,719 reads
This is a PASS VC Webinar, taking place on August 28, 1PM EDT. Get interviewing tips from both sides of the desk. Based on Thomas LaRock's 10 Things blog posts, this presentation by both Thomas LaRock and Karen Lopez will give you valuable insight into the interviewing process and how to improve your chances of landing that next job.
2013-08-26
2,736 reads
This PASS VC Webinar will take place August 14, 1PM EDT. Creatively resolving differences and negotiating mutually beneficial agreements is crucial in all walks of life. It’s especially important and challenging in the IT industry where soft skills are not necessarily prevalent. ??In this session, we’ll introduce the basic concepts and precepts that will aid you in negotiating better agreements with your neighbors, peers and co-workers, and even your boss.
2013-08-12
2,763 reads
On Thursday June 20 at 12 noon Central time, Steve Simon will discuss the challenges of designing financial warehouses.
2013-06-18
3,871 reads
On Thursday May 16th 12PM Central time, Robert Davis will discuss public facing websites on a global scale when looking at Data Architecture.
2013-05-14
3,400 reads
On Thursday August 20th 12PM noon Central, James Serra will discuss how companies can consolidate their enterprise data with the new feature of SQL Server 2012 Master Data Services.
2012-12-20 (first published: 2012-12-18)
2,340 reads
On Thursday August 16th 12PM noon Central, Louis Davidson will do a design and code review of several common patterns of solving problems that a typical programmer will come up against in SQL Server.
2012-08-15
1,182 reads
On Thursday July 26th 12PM noon Central, Ami Levin will revisit some of the fundamental principles of relational databases – normalization rules, key selection and some controversies surrounding these rules.
2012-07-25
1,559 reads
On Tuesday June 19th 12PM noon Central, Neil Hambly will discuss "Leveraging the power of constraints to improve both data quality and performance of your databases."
2012-06-19
3,690 reads
Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...
This comic was retweeted into my timeline on Twitter (I refuse to call it...
By Steve Jones
Recently I’ve been looking at archiving some data at SQL Saturday, possibly querying it,...
My agency has been using the combo of on-premises SQL Server for the back...
Development Environment I am learning how to use pyodbc and accessing database in SQL...
We are seeing multiple frequent deadlocks occurring with the following extract of code, which...
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