Day 3 at TechEd 2005
TechEd is a great show and while the PASS summit is the best one for DBAs, this one is great for most of the other Microsoft technologies. Read about Day 3 from Steve Jones.
Real World Query Plans
The SQL Server 2000 Query Optimizer is one of the more complicated things that a SQL Server DBA deals with. For most of us, we just let it work and do not give it a second thought. But when a crisis occurred, Andy and Steve had to dive in to learn a few more things about it.
Day 2 of TechEd
Day 2 from TechEd, this time from Brian Knight's perspective as the SQLServerCentral.com crew enjoys a week of learning and sun at the 2005 conference.
Help Us Out For A Free Gift
We would like to offer a free copy of the May 2004 SQL Server Standard magazine to everyone who can take a couple minutes to update some demographics for us.
Meet the SQL Server Team
They have been very hard at work trying to get SQL Server 2005 ready for release, but many of them have been given a week's break after IDW15 to come down to TechEd. They've created an interesting diary that you can view.
Enumerate SQL Server Names from "SQL Server Enterprise Manager"
Occasionally, SQL Server database administrators are requested to provide a list of development SQL Servers, production SQL Servers and so on. Many articles, such as "Monitor Disk Space on Multiple SQL Servers" and "Inventorying hardware and OS information on all SQL Servers" require a list of servers in a text file.
Day 1 at TechEd
It's not a SQL Server event, but SQL Server is a large part of it. TechEd is a huge conference and one of the premier events put on by Microsoft each year. Read about the first day with Andy, Brian, and Steve.
SQL Server 2005 System Tables and Views
When a SQL Server object is created, its properties are called metadata. The metadata is stored in special System Tables. For example, in SQL 2000, when a new column was created, the column name and data type could be found in an internal System Table called syscolumns. All SQL objects produce metadata. Every time SQL 2000 Enterprise Manager or SQL 2005 SQL Server Management Studio is browsed, the information displayed about database, tables, and all objects, comes from this metadata.
Suggestions for Datatypes
SQL Server 2000 does a lot of things for the DBA, tuning, updating statistics, scheduling tasks, wizards and more. But one thing that it does not help with is choosing the correct data type for your data. New author Amit Lohia brings us a technique and some code that will examine your existing data and suggest places where another data type might be a better choice.
Blogs
Learn Better: Pause to Review More
By Brian Kelley
If you want to learn better, pause more in your learning to intentionally review.
Azure SQL Managed Instance Next-Gen: Bring on the IOPS
By John
If you’ve used Azure SQL Managed Instance General Purpose, you know the drill: to...
SQL, MDX, DAX – the languages of data
By DataOnWheels
Ramblings of a retired data architect Let me start by saying that I have...
Forums
Two foreign keys to the same table. Can't cascade deletes.
Not sure if this is really a relational theory question but it seems about...
Connecting Power BI to SSAS and effective user not working
Hi everyone, Below is a consolidated summary of what we validated Architecture & data...
High Availability setup - has anyone seen this method?
Hi all, I recently moved to a new employer who have their HA setup...
Question of the Day
Encoding URLs
I have this data in a SQL Server 2025 table:
CREATE TABLE Response ( ResponseID INT NOT NULL CONSTRAINT ResponsePK PRIMARY KEY , ResponseVal VARBINARY(5000) ) GOIf I want to get a value from this table that I can add to a URL in a browser, which of these code items produces a result I can use? See possible answers