Be on the lookout for the mistakes of others
I've come to learn that there are some really flaky systems out there. Not just a few quirks here and...
2006-06-15
1,385 reads
I've come to learn that there are some really flaky systems out there. Not just a few quirks here and...
2006-06-15
1,385 reads
I found out today that I will get to attend the SQL Server Magazine Connections conference (part of the DevConnections...
2005-12-21
1,398 reads
A quick and dirty procedure to allow you to grant execute permissions to a user, or role, quickly and easily.
2005-12-13
9,947 reads
Everyone seems to focus on the large scale, enterprise level installations of SQL Server with not a lot of information on the little guy. To that end, new author Tim Mitchell brings us a great overview on what you should consider when setting up a SQL Server environment for a small scale setting.
2005-11-14
8,221 reads
Day Four wrapped up SQL Pass 2005. As a first time attendee to this event, my head was swimming by...
2005-10-01
1,351 reads
Day Three of PASS had a decidedly better start than did the previous day. After finally figuring out the effective...
2005-09-29
1,294 reads
This year, I have the opportunity to attend the SQL PASS event in Grapevine, Texas. This is my first PASS...
2005-09-28
1,407 reads
Day Two at PASS started out on a sour note. Rewind about 36 hours, to when I was checking in...
2005-09-28
1,539 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
How can I check what value I used for TEXTSIZE? I ran this code:
SET TEXTSIZE 8096But then deleted the code and couldn't remember. Is there a way to check this? See possible answers