Building a Demo Server - Part 2
Everyone does demos. You need them to sell your software, but the demo server presents some challenges. Continuing this series, this article looks at moving data between servers.
Setting a Default Database for your Logins
Andy discusses reasons why he thinks setting the default database to anything other than master is a mistake. We think he does a good job of covering the pros and cons, read the article and join the discussion!
How Safe are Your Passwords?
How safe are your SQL passwords? Use these free tools to find out how secure your passwords are and generate more secure passwords.
Utilizing fn_virtualfilestats
In this example, we will attempt to get some statistical information on file-group utilization to assist us with IO monitoring.
Comments on PASS Community Summit 2002
Andy attended the recent PASS Community Summit and had a great time. Read some of the highlights from his perspective and maybe decide that you'll want to attend next year!
Pro Developer: Improving Your Career In Any Economy
Like many other areas of business, the tech industry has weathered the occasional slump over the past few decades. It's only natural that the fate of techies is closely linked to the tides of the business. However, in any economy, weak or strong, some people prosper and advance while others suffer the consequences.
Review of Developing Windows Based Applications for VB.Net and C#.Net
Andy talks briefly about why the company he works for has decided to require all developers to obtain the MCSD, then takes a look at the book they chose for the initial round of study for the first exam.
How to Diagnose and Fix Wait Locks
This article by new columnist Cathan Kirkwood shows you how to find wait locks and eliminate them.
Blogs
Accept the no and move on
By Brian Kelley
Here is a short emotional intelligence (EI) post for today, courtesy of Seth Godin....
Don’t Fight with AI
By Steve Jones
I was recently trying to handle a simple task with a few AI tools...
Narrow Task Decomposition in AI Pipeline Agents
A nightly load into sales_fact fails. Ask an orchestrating agent to break down the...
Forums
jdbc auth failing to sql from sap's cloud middleware CPI
hi , our business partner is asking s4 sap api's for receivable info and...
Searching for my own posts
I have a really stupid question... Is there an easy way to search for...
How to Work with On-Premises AI Models to Generate T-SQL Code
Comments posted to this topic are about the item How to Work with On-Premises...
Question of the Day
Escaping Strings
The STRING_ESCAPE() function requires 2 parameters in SQL Server 2025. The first is a string of text and the second is the type of escape rules being used. What are the options for the second parameter?
See possible answers