The PASS 2007 Round Up
A list of articles and comments, including some pictures, from the 2007 PASS Summit in Denver.
2007-10-03
1,185 reads
Steve Jones
- Interests: yoga, reading, biking, snowboarding, volleyball
- Twitter: @way0utwest
- Website: https://www.voiceofthedba.com
- LinkedIn: https://www.linkedin.com/in/way0utwest
The Value of Information
If I have accomplished anything, it is because I have stood on the shoulders of giants.
2007-10-03
160 reads
Auditing Your SQL Server - Part 2
This article expands Steve Jones' look at ways to audit changes to your data by building mirror tables.
2007-10-02 (first published: 2003-03-17)
22,320 reads
Beginning SQL Server - Limit Your Queries
Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.
2007-10-02 (first published: 2004-08-19)
36,175 reads
Beginning SQL Server - Logins and Users
Part 3 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product. This article looks at logins and basic security.
2007-10-02 (first published: 2004-09-02)
41,562 reads
Coding Standards - Part 1
A look at coding standards in SQL Server. The first part of this series deals with object naming standards.
2007-10-02 (first published: 2002-05-09)
49,262 reads
Estimates - Part 1
I saw a very interesting post about estimating software from Steve McConnell, of Code Complete fame. He compared his estimate...
2007-10-02
1,000 reads
Half a Million
We crossed the 500,000 member mark last week and we're looking to give away some prizes!
2007-10-02
1,909 reads
Query Analyzer Tricks
Query Analyzer is a great tool for developing SQL code. There are a number of little tricks that can greatly increase the amount of work you can do with very little effort. This article starts looking at some of the features of this tool.
2007-10-02 (first published: 2003-01-07)
70,267 reads
Reminiscing
Steve Jones has been working with SQL Server for 10 years. Join him for a stroll down memory lane.
2007-10-02 (first published: 2002-05-23)
5,768 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers