A little restriction that prevent changing tables in SQL Server 2008
In SQL Server 2008, by default, the option to prevent tables changes is "on". We can have some issues and...
2010-03-24
4,013 reads
Dukagjin Maloku
- Interests: Database Admin & BI
Little info about Resouce DB (SQL Server 2008-2005)
Little info about System Resource Database in (SQL Server 2008/2005)
The fifth system database in both versions (SQL Server 2008 - 2005)...
2009-12-29
2,258 reads
Blogs
The 5 Best SQL Course for Beginners – Reviews and Guide
In the technologically driven world of 2024, more individuals are finding themselves drawn towards the...
Speaking at SQL Saturday Boston 2023
By Steve Jones
I’m heading to Boston next week for SQL Saturday Boston 2023. I went to...
Using the Pure Storage PowerShellSDK2 - Part 1 - Connecting to FlashArray
In this series of blog posts, we’re diving into how to use the Pure...
Forums
temp table filtering with Joins question
Hello Gurus for one use case we converted the code to use temp tables...
checkdbcc date for all database
CREATE TABLE #tempdblogin ( lastcheck nvarchar(100) ) EXEC sp_MSforeachdb 'USE ? insert into #tempdblogin...
Azure Postgres reliability/management experiences
I am considering implementing an Azure Postgres DB for use in a part of...
Ask SSC