Odd
trivia...who do you know that has "S", "Q", and "L" contained in their
last name
(like SQUILLACE)?
Make sure you visit my SQL Server Screenshot Gallery page!!!
For links to SQL Server samples on CodePlex click here
Contains samples for:
- Database samples
- Database Engine
- Database Development
- SSAS
- SSRS
- SSIS
- Service Broker
...and more.
See also...Study Notes
- Course 2071 T-SQL Querying study notes [incomplete]
- Course 2072-Admin study notes
- Course 2073-Database Programming study notes
...which contain pages with a comprehensive list of system-stored procedures, functions and statements that you learn in these courses (not necessarily beautifully formatted)!
DML Query clause order (for SELECT, INSERT, UPDATE, DELETE)
Select ____(something or everything)
From __________
Join _____ on _____
Where ____________
Group By
____________
Having
_______________
Order By
_______________
Remember this as "SFJOWGHO". Does that help?
Student Susan Svoboda suggests "Some Freak JO Watches GHOsts."
See the SQL Server Cool Third Party Products page.
|
SQL Server & .NET Developer User Groups |
|
|
Meets at Microsoft's office in Southfield, MI on the 19th floor. Now affiliated with PASS (www.SQLPASS.org). |
|
|
West Michigan SQL Server Users Group
Previous URLs: http://wmsql.org. |
Inaugural meeting was held on Wed., August 8th, 2007 at Alticor's (Amway) headquarters. Also now affiliated with PASS. |
|
Chicago.SQLPASS.org. |
|
|
Ohio North SQL Server Users Group (Cleveland) |
OhioNorth.SQLPASS.org. |
|
|
|
To find other SQL User Groups click here to find the PASS chapter locator. |
|
|
Greater Lansing (& Flint) User Group .NET (GLUGNET) |
A .NET developers group. www.GLUGNET.org, meetings in both Lansing (Anthony Hall at MSU) and in Flint (New Horizons Computer Learning Centers - Flint) |
|
"For Developers, by Developers". Meets at Microsoft's office in Southfield, MI. |
|
|
Meets currently at New Horizons in Grand Rapids, MI. |
|
|
SQL Server Newsletters & free training resources |
|
|
MSSQLTips.com newsletters
|
My recommendation is to subscribe to the regular |
|
Simple-Talk.com newsletters (RedGate) |
|
|
SQLServerCentral.com newsletters |
|
|
SQLShare.com (videos) |
|
|
Pragmatic Works free webinars "on the T's" |
Free webinars offered most Tuesdays and Thursdays over a broad range of SQL Server topics. |
|
"SQL Lunch" free webinars |
|
|
SQLSaturday conferences
The event on September 17, 2011 was a great success. Look for other upcoming SQL Saturday events near you!
|
Free, one day conferences throughout the USA and beyond. |
|
|
|
|
Microsoft home page for SQL Server |
|
|
Microsoft's home for SQL Server Technologies |
|
|
Microsoft's SQL Server TechCenter (Microsoft TechNet) |
|
|
AdventureWorks schema diagrams (several diagrams, covers > 1 version of SQL Server) |
From CodePlex, includes data warehouse, OLTP, and light schema versions. |
|
Includes version history, codenames, some release dates, and more. |
|
|
Recommended favorites/bookmarks to make in SQL Books Online (BOL) for SQL 2000 |
|
|
SQL Admin & Developer Tips & Tricks |
From Microsoft's website |
|
Includes good bookmarks to SQL tool shortcuts! |
|
|
|
|
|
Found at the SQLSummit website. |
|
|
Other Relational Database Management Systems (RDBMS) Offerings |
A feature matrix. |
|
SQL Server facts to document (under development) |
|
|
Suggested Content for "Run Book" for SQL Server |
A Microsoft TechNet resource, from the SQL 2000 Server Operations Guide |
|
An article from Chris Randall. |
|
|
From www.MSSQLTips.com. |
|
|
From Josh Robinson's blog. |
|
|
A resource from Simple-Talk by Buck Woody. It details Daily, Weekly, Monthly, etc. maintenance tasks. |
|
|
|
|
|
Database Administration topics (I am doing a lot of reorganization of topics at the moment) |
|
|
Microsoft KB321185. |
|
|
From MSSQLTips.com, by Greg Robidoux. |
|
|
Free eBook by Quest on Query Tuning, Index Maintenance, and other Performance Optimizing Topics...argh, 145pp! |
|
|
Tips for New DBAs (a series of posts) |
From SQLServerCentral.com by Craig Outcalt. |
|
From DatabaseJournal.com, by Muthusamy Anantha Kumar aka "The MAK". |
|
|
From SQLSkills.com, a blogsite and more. This misconception series is from Paul S. Randal. |
|
|
From Simple-Talk.com by Brad McGehee.
In fact, here's a list of a bunch of free RedGate/SimpleTalk eBooks. |
|
|
eBook "SQL Server Statistics" |
From Simple-Talk by Holger Schmeling. |
|
How to Rebuild the System Databases (like Master) in SQL 2008 |
|
|
Default trace - A Beginner's Guide (SQL 2005 and beyond) |
By Adam Haines at SQLServerCentral.com. The article details how the system is capturing detailed info (that could answer "Whodunit?" types of questions) and is enabled by default. |
| "Guts of a Clustered Index" | A September 14, 2010 blog post from "the DBA Whisperer", Michael J. Swart, which also details some .MDF internal details. |
|
How to Connect to a SQL 2005 Server When You Are Completely Locked Out |
From MSSQLTips by Rudy Panigas. |
|
From MSSQLTips by Aaron Bertrand. |
|
|
Iterating Through SQL Server Databases and Database Objects Without Cursors |
From MSSQLTips by Arshad Ali. Also discusses the use of sp_ForEachDB and sp_ForEachTable. |
| SQL Server DMV Starter Pack |
From Brad McGehee at RedGate; contains an eBook and more than 30 scripts! |
|
"Defining and Establishing SQL Server Policies and Procedures" |
From MSSQLTips by Greg Robidoux. |
|
From SQLServerCentral.com by Mauro Pichiliani. |
|
|
SQL Server Browser Service details |
An MSDN reference. |
|
Choosing a
Network Protocol |
An MSDN reference. |
|
From MSSQLTips by Alan Cranfield. |
|
|
SQL 2012-specific References |
|
|
Download the SQL 2012 Product Guide |
|
|
SQL
2008-specific References |
The product 'RTMd' in mid-August 2008 |
|
As of April 21, 2010, SQL 2008 R2 has reached RTM status. |
See also this PR link. |
|
An MSDN resource listing what's new, changed, and unchanged. |
|
|
Free eBook, "Introducing SQL Server 2008 R2" |
by Ross Mistry and Stacia Misner. |
|
From Microsoft's SQL Server site. |
|
|
A Word document from Microsoft Downloads. It's 15 chapters and two appendices! |
|
|
SQL Server 2008 Edition comparison matrix Hardware & Software Requirements, such as which Editions are compatible with which Operating Systems. |
A Microsoft resource. |
|
44 MSDN whitepapers on various SQL 2008 topics |
|
|
An MSDN resource. |
|
|
HierarchyID articles [in-progress]
|
by Itzik Ben-Gan, SQL Mag |
|
SQL Mag Instant Doc #100515, by Derek Comingore. |
|
|
From MSSQLTips.com by Ray Barley. |
|
|
|
|
|
SQL 2005-specific References |
The product 'RTMd' November 7th or 8th 2005
|
|
A Microsoft reference (as a Word document)...30 pages including Case-study appendices! |
|
|
A Microsoft reference divided into: |
|
|
Microsoft Events...Upgrade Your Skills (SQL Server 2005) |
Webcasts, Virtual Labs, and Podcasts! |
|
A list of the new features and improvements that are included in SQL Server 2005 SP1 |
KB 916940 |
|
|
|
|
An MSDN reference regarding the upgrade of the Database
Engine, |
|
|
Microsoft SQL Server 2005 webcasts... |
...includes webcasts from Kimberly Tripp for SQL 2000 DBAs as well as for those starting new with SQL |
|
A Microsoft resource (long web page). |
|
|
Downloadable preparatory software tool from Microsoft |
|
|
Feature Comparisons...
|
From MDSN. Extremely thorough [wacky URL]. |
|
SQL Server Integration Services (SQLIS.com) |
Reference website. |
|
Some interesting facts on Database Snapshots... |
...such as finding out how much space is occupied by the snapshot pages. A blog entry by a SQL MVP. |
|
"SQL Server Profiler: Features, Functions and Setup in SQL Server 2005" |
Found at SearchSQLServer.com. |
|
Database Concurrency and Row Level Versioning in SQL 2005 |
A Microsoft TechNet resource. |
|
Learn more about SQL Server 2005 with these podcasts |
From www.sqldownunder.com. |
|
An outstanding feature comparison by Microsoft. |
|
|
Scalable Shared Databases in SQL Server 2005 |
Microsoft Knowledge Base article Q910378. |
|
An MSDN Blog entry. |
|
|
Microsoft website references. |
|
| Transactional Replication Setup | From SQLServerCentral.com by Abi Chapagai. Quite a number of screenshots, too. |
|
i.e., after you fix torn pages why they still appear in msdb.dbo.suspect_pages? This article helps you understand more. Thanks, student Mike Blake (Troy, MI) for asking the question about the suspect_pages table which led to this link. |
|
|
Excellent, thorough reference from Kimberly Tripp on MSDN. Or this URL. |
|
|
Designing Partitions to Manage Subsets of Data The code to go along with the above example. (Sliding Window example) |
MSDN resources which shows how to load into and switch partitions. Great example.
|
|
A blog post from Stefano Demiliani. |
|
|
SQL Mag, Instant Doc #96058. |
|
|
Interesting article by Rob
Garrison of SQLJunkies.com. |
|
| Clustering & High Availability Resources and Links | See the Third Party Tools
section also!
|
|
Make sure you check out my Virtualization home page, which has some clustering links specifically related to virtualization. |
|
|
A webpaper from Microsoft.
|
|
|
A downloadable paper from Microsoft.
|
|
|
SQLShare website (formerly known as "JumpstartTV") |
A site assembled from Microsoft MVP Brian Knight, with many multimedia presentations about various technology areas, such as Windows Clustering, SQL Server, including installing SQL Server into a Cluster. |
|
Database Mirroring Best Practices and Performance Considerations |
Microsoft TechNet reference |
|
MS TechNet
resource. Implementing
Failover Clustering |
|
|
Comparison of High Availability Technologies - COMPLETED.doc
Comparison of High Availability Technologies - COMPLETED.PDF |
Primarily a reference/resource for Microsoft Course 2788A, Designing High Availability Database Solutions with SQL Server 2005 |
|
Other Reference Articles & Websites |
|
|
With NOLOCK (Home of the Dirty Read) |
Reference website, Blogs, and downloads. Some MDX stuff too. |
|
Microsoft TechNet huge list of resources such as deep whitepapers and tools. |
|
|
Database Journal Daily Database News, Information and Tutorials for the Database Professional |
|
|
Controversial article about database theory. |
|
|
"The online community for database issues and solutions". |
|
|
|
|
|
From databasejournal.com |
|
|
Reference information |
|
|
|
|
|
Building a Package in the DTS Designer |
From SQLDTS.com There are a surprising number of DTS book titles available for DTS help also. |
|
|
|
|
History of MS SQL Server versions |
See Instant Doc 37471 at SQL Server Magazine |
|
SQL Course.com website |
Free, interactive, online SQL Training (database agnostic [not specific to a particular database brand]) |
|
SQLCourse2.com website |
See "SQLCourse.com" above |
|
Interesting info on the Slammer/Sapphire Worm from CAIDA |
|
|
Database Debunkings website |
by Fabian Pascal |
|
An article on SQL Server "Security Account Delegation" |
Relates to Linked Servers (Q319723) |
|
Reference blogsite/website from Kimberly Tripp, Bob Beauchemin (both SQL MVPs) and others. |
|
|
Downloadable tool from Microsoft. |
|
|
Simon Sabin's blog (UK consultant and SQL MVP) |
This particular link lists a number of videos available from SQLBits V. |
|
A lesson on database normalization |
From DatabaseJournal.com, Ian Gilfillan. |
|
Free Visio Add-in from Microsoft. Has videos and reference documentation also. |
|
|
How to map the \MSSQL.n\ folder to its parent component |
See BOL "File
Locations for Default and Named Instances of SQL Server 2005". |
|
Simple-Talk, "SQL Server and .NET put Simply" |
Reference website, some interesting articles found there, such as Partitioned Tables in SQL 2005 and XML references. |
|
What is a DBA? (six part series from the DBAZine website) |
|
|
See my Copy, Move, Rename, Detach, & Attach Database procedure page |
|
|
What if you rename the Operating System that SQL Server sits on? |
|
|
Sometimes SQL Server is limited to using Outlook 2000...many other good mail/SQL related links in Q897349 |
|
|
A Useful Article on Database Normalization |
|
|
Which edition and version of SQL Server 2000 do I have?
|
Microsoft KnowledgeBase Q321185 |
|
How do SQL Server 2000 & AD relate? |
WindowsITPro article #41841 |
|
How To Set the SQL Server Network Library in an ADO Connection String |
Microsoft KB238949
• dbnmpntw - Win32 Named Pipes |
|
How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port |
Microsoft KB823938 |
|
|
|
How to determine the patch and service pack level your SQL Instance |
From SQLSecurity.com. One of my students, Ken Klaft (Toledo, OH) maintains this page. |
| SQL Performance related links | See the Third Party Tools
section also!
|
|
Or, download his eBook, |
By Grant Fritchey, of Red Gate / Simple-Talk. |
|
By Brad McGehee at Red Gate. |
|
|
This may help whether you're a German language speaker or not.
|
|
|
SQL-Server-Performance.com reference website. Check also the screen captures of SQL Server cluster installation steps. |
|
|
Free tool, SQLQueryStress |
A performance testing tool by Adam Machanic. |
|
by Kalen Delaney, SQL Mag InstantDoc 19851 ...and InstantDoc 20242 ...and InstantDoc 20589
|
|
|
SQL Mag InstantDoc 24382
|
|
|
A Microsoft TechNet reference.
|
|
|
Introducing SQL Internals Viewer .11 Beta by Danny Gould |
"...a tool for looking into the SQL Server storage engine and seeing how data is physically allocated, organised and stored. Free. Found at www.SQLInternalsViewer.com |
|
Uses SQLDiag in the back-end. SQLMag InstantDoc# 96744.
|
|
|
By Quest, a PDF. Free. And don't forget to look at the video tutorial on the same subject found at this same link. |
|
|
"Clustered Index Seek vs. Scan" "Indexing Best Practices", by Kimberly Tripp SQL Server Query Execution Plan Analysis Clustered Index Scan Showplan Operator {MSDN BOL} Clustered Index Seek Showplan Operator {MSDN BOL} |
|
|
This article shows how to write an app that extracts estimated execution from XMLShowplan and then limits execution based on a predefined threshold. |
|
|
How Does the AutoUpdate Statistics (AutoStats) Feature Work? |
Microsoft KB Article 195565.
|
|
Statistics Used by the Query Optimizer in Microsoft SQL Server 2000 |
How does SQL Server Use (Index Distribution) Statistics?
|
|
Using SQL Server Profiler Black Box feature |
by Kalen Delaney on SQLMag, InstantDoc #16078.
|
|
A book excerpt on SQLDiag and Black Box Profiler |
From "SQL Server 2000 for Experienced DBAs" written by Brian Knight |
|
By Sylvia Moestl Vasilik at SQLServerCentral.com. |
|
|
The Winter Corp inventories the largest databases on the planet... |
...which they call "The Top 10 Program".
|
| Third Party Vendor Tools for SQL Server |
|
|
Apex SQL Tools |
There are
several tools, including: ApexSQL Dev Studio, ApexSQL Univ Studio,
ApexSQL Audit, ApexSQL Clean, ApexSQL Code, ApexSQL Diff, ApexSQL Doc,
ApexSQL Edit, ApexSQL Log, ApexSQL Report, |
|
Charonware (now Quest) TOAD Data Modeler |
Freeware, at least at one point. I think you have to buy it now. |
|
|
|
|
A free SQL Server performance monitoring dashboard. |
|
|
Lumigent Log Explorer (see also ApexSQL Log) |
A tool to read the Log file, roll back...VERY NIFTY tool. The demo comes with a tutorial...huge! |
|
Neverfail for Microsoft SQL Server |
an HA solution from NeverfailGroup |
|
|
|
|
WANSync & WANSyncHA |
an HA solution from XOSoft |
|
They make a number of tools |
|
|
Ignite for SQL Server, a "performance intelligence" tool |
by Confio |
|
Gridscale for SQL Server, a High Availability product |
by xkoto; the product is currently in beta (July 2008) |
|
An article from Windows IT Pro (Instant Doc 38737) that describes SQL add-ons |
|
|
Dundas Chart for Reporting Services |
|
|
Chart FX by Software FX |
|
|
Such as... |
|
|
Nifty resource from Microsoft. Formerly at this URL. |
|
|
Express Edition Beginning Developer Learning Center |
|
|
Get Started section of the www.ASP.net website |
A number of multi-media presentations to learn more about ASP .Net including starting with Visual Web Developer Express. |
| Recommended SQL-related books |
|
|
My library books here... |
Or, do a search on this site for "library" which will get you to my list of library books. |
SQL Server Security |
General Security, Encryption, and more... |
|
Free eBook, "Protecting SQL Server Data" |
by John Magnabosco; a Simple-Talk resource. At the time of linking to this the download actually included three other eBooks! |
|
SQLMagazine reference by Omri Bahat, InstantDoc #95728. |
|
|
Understanding When Kerberos Delegation Is Needed for SQL Server |
From MSSQLTips, by K. Brian Kelley. |
|
How to Implement Kerberos Constrained Delegation with SQL Server 2008 |
An MSDN resource by Kevin McDonnell. |
|
SQLMagazine reference by Omri Bahat, InstantDoc #95728. |
|
|
An MSDN resource. |
|
|
by Kevin Kline, SQLMag Instant Doc #100720, February 2009. |
|
|
SQLPing utility, used to find all instances of SQL Server on your network |
From SQLSecurity.com. Thanks, Ken Klaft, for notifying me of this utility. |
|
A DatabaseJournal.com article by Marcin Policht. |
|
|
A Microsoft MSDN Reference and picture. |
|
|
Protecting Connection Strings and Other Configuration Information |
Microsoft MSDN Reference (there is also a C# version of this tutorial, but I bookmarked the VB .NET version). |
|
Building Secure ASP.NET Applications: Authentication, Authorization, and Secure Communication |
Microsoft MSDN Reference, detailed, fairly lengthy |
|
From MSSQLTips. |
|
|
SQLMag May 2008, InstantDoc #98576. |
|
|
A script, by Richard Lu, at SQLServerCentral.com, to inventory all permissions for logins. Very nifty. |
|
|
|
|
|
A SQLServerCentral.com post by Doug Lutz. |
|
|
Microsoft MSDN Reference. |
|
|
|
|
| The webcasts cover all sorts of topics. | |
| The webcasts cover all sorts of topics, including "Truly Level 400 Performance Monitoring & Tuning". | |
|
From Simple-Talk. Covers many areas of the product including data warehousing, Reporting Services, XML, and more. |
|
|
"SQL
Server Tacklebox - eBook", |
From Simple-Talk. Covers many topics related to DBAs. |
|
Best of SQLServerCentral.com - Volumes 1-4 Best of SQLServerCentral.com - Volume 5 |
Articles from SQLServerCentral.com, compiled in eBook format. |
|
By "Phil Factor" at Simple-Talk. |
|
|
Rip-Off! - the Free Ebook |
From Simple-Talk,... "The scandalous inside story of the consulting money machine. Lying, cheating, falsifying results, plagiarism, incompetence, manipulation, tax evasion, expenses fraud, sex and alcohol abuse..." |
