Degree Seeker Week at SQL University, Lesson 2
Degree Seeker Week at SQL University, Lesson 2
Welcome once again eager learners to Lesson 2 of Degree Seeker Week at...
2010-07-08
2,223 reads
Robert Davis
- Interests: Poker, computers, reading/writing horror fiction
Degree Seeker Week at SQL University, Lesson 3
Degree Seeker Week at SQL University, Lesson 3
Welcome back eager learners to Degree Seeker Week at SQL University. I’m your...
2010-07-08
2,711 reads
Degree Seeker Week at SQL University, Lesson 1
Degree Seeker Week at SQL University, Lesson 1
Welcome eager learners to Lesson 1 of Degree Seeker Week at SQL University....
2010-07-05
2,623 reads
T-SQL Tuesday #008: Gettin’ Schooled
T-SQL Tuesday #008: Gettin’ Schooled
“Thank you fans and friends & odds and ends. And now for you gals and guys, a...
2010-07-04
9,227 reads
Extracurricular Activities
Extracurricular Activities
Recently I presented two sessions at SQL Saturday #43 in Redmond, WA. The night prior to the event, many...
2010-07-03
697 reads
The Trade Deadline Must be Drawing Near
The Trade Deadline Must be Drawing Near
Okay, so there is no trade deadline in SQL Server like there is in...
2010-06-29
2,130 reads
Error 25602 When Creating an Extended Events Session: a Security Risk
Error 25602 When Creating an Extended Events Session: a Security Risk
I came across an interesting issue recently when helping someone...
2010-06-23
3,503 reads
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
How Do I ... Get a List of Tables With Data Modifications in a Specific Timeframe?
There was a question on a...
2010-06-18
1,923 reads
Building HTML Emails With SQL Server and XML
Building HTML Emails With SQL Server and XML
I’ve written a lot of custom reports in my days that output data...
2010-06-15
62,380 reads
SQL Saturday #43 in the Books
SQL Saturday #43 in the Books
Another great SQL Saturday is in the books!! I had submitted 2 sessions, but there...
2010-06-12
901 reads
Blogs
Using Cron in Postgres Flex
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
Can I Change a Primary Key Value? #SQLNewBlogger
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
SQL Server Index Primer
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Forums
How do you keep track of the purpose for SQL Logins?
Wondering how others keep track of the purpose for SQL Logins? I'm not talking...
Just a rant about the SQL Server 2022 upgrade
Upgrading an instance of SQL Server 2019 to SQL Server 2022 - I am...
Report Server Configuration Manager - The target principal name is incorrect SSL
SQL Server SSRS 2022. Running into ' SSL Provider, error: 0 - The target...
Question of the Day
Getting the TEXTSIZE
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