SQL Saturday #63 – Dallas: Resources
I had the opportunity to present my “What Can You Do With PowerShell?” session in Dallas at SQL Saturday #63....
2011-04-02
643 reads
Blog Posts
SQLSaturday #63, Great Event!
So,
I actually had a early morning sessions and gave my Solid State Storage talk and had a great time. The audience was...
2011-04-02
638 reads
SSMS Tips & Tricks – Scripting Multiple Objects
This is one that I figured most everyone would know, but repeatedly over the past couple weeks in my office,...
2011-04-02
1,360 reads
T-SQL LOWER(): Change an all uppercase string to lower case
The T-SQL LOWER() command allows you to change an uppercase string to a lowercase string.
For example, it will allow you to change the word...
2011-04-02
894 reads
A 22 Hour Layover
I joked about having a 22 hour layover in Denver yesterday and a few people were wondering what airline screwed...
2011-04-01
849 reads
Announcing The Association For SQL Server
Recently there have been a number of PASS members who have become unhappy with the direction of the organization and...
2011-04-01
399 reads
April Question: Which high availability option(s) do you employ for SQL Server instances, and why did you choose them?
As DBAs, we are responsible for the protection of our organization’s data, and we have many different options to protect...
2011-04-01
598 reads
Changing Directions
I See Dead Tech….
Knowing when a technology is dying is always a good skill to have. Like most of my...
2011-04-01
918 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In SQL Server an index helps to improve query performance...
2011-04-01
8 reads
Indexing Just Got Easy
As a database professional one of the things that we should be familiar with is the use of indexes. In...
2011-04-01
663 reads
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
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
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