The ROI for PASS 2009
A few of the reasons why you might want to attend the PASS Summit this November.
Auto Generate an Hourly SQL Server Profiler Trace File
I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.
How to Calculate Data Warehouse Reliability
This article outlines a more objective and analytical approach to the ETL and data flow architecture selection based on a set of variables with an objective to enhance the reliability of the overall data warehousing solution.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Security Focus
Are IT administrators focusing on the wrong attacks when securing their systems? Should we as DBAs and developers care? Steve Jones argues that we want to be aware of these issues.
Celko's SQL Stumper: The Data Warehouse Problem
Joe Celko comes back with a puzzle that isn't new, but one where the answer he originally gave now seems archaic: It is a deceptively simple problem, but is it true that the new features of SQL have simplified the solution? We leave it to the readers to provide the answer!
Importing Data and New Hardware (Database Weekly)
Steve Jones looks at some of the interesting news this week in the SQL Server world.
Your Point of View
The way that you view the world is often different that the way others might. It can be helpful to remember that when you are trying to work with others, or even critique their work. Steve Jones talks about the need to remember that as you progress in your career.
Architectural Options for Asynchronous Workflow
This article describes the benefits of asynchronous processing and discusses three possible ways to implement this type of workflow within your own systems.
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers