PASS Update #49–SQLRally
I get a lot of questions about how SQLRally is going, which tells me that there is a lot of...
2011-01-20
639 reads
Blog Posts
Policy for Ad-hoc Workloads
During my presentation at SQLSaturday 62 in Tampa I was asked by an attendee about having a policy to check...
2011-01-20
926 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually means something to a SQL person whenever we ca. ...
2011-01-20
9 reads
PowerShell Week at SQL University – Post 5
In the previous posts we’ve just been poking around with PowerShell and trying to make the examples something that actually...
2011-01-20
1,205 reads
Remember OBJECTPROPERTY(..) when investigating objects.
The object property function appears to be often overlooked.
This function will tell us about any schema scoped object in the...
2011-01-20
1,303 reads
SSMSDeploy 1.1 Now Available
Fixed a couple of issues and made some GUI tweaks. Please see the download page for the latest version, and...
2011-01-20
716 reads
Tips & Tricks for DBAs Writing Their First Article
I have been writing full or part-time for nearly 30 years, and I have written and edited hundreds of articles....
2011-01-20
1,366 reads
31 Days of SSIS – SQL Server Configuration (18/31)
31 Days of SSIS
The last post in the 31 Days of SSIS talked about the use of environmental variables. As...
2011-01-19
2,221 reads
How to find the SQL server port number
Advertisements
One day I got a call from my junior DBA. She asked me, how can I find out the port...
2011-01-19
578 reads
New Book: Introduction to SQL Server
Last year, Kevin Kline (blog | twitter) introduced me to Oracle and database expert, Bert Scalzo. Bert was looking to take...
2011-01-19
604 reads
Blogs
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Learning Tool – Deepstash
By Brian Kelley
A few months ago I started using Deepstash. Deepstash breaks books into the key...
Forums
When the Token Meter is Zero
Comments posted to this topic are about the item When the Token Meter is...
Understanding Temp Tables and Table Variables in SQL Server
Comments posted to this topic are about the item Understanding Temp Tables and Table...
The Data API Builder MCP Server Tools
Comments posted to this topic are about the item The Data API Builder MCP...
Question of the Day
The Data API Builder MCP Server Tools
The Data API Builder MCP Server, v2.x, includes a number of tools. What actions can these tools perform in your database?
See possible answers