Keep an eye on those Audit files!
This month’s T-SQL Tuesday (#71) is hosted by Sebastian Meine (b/t). He has picked an interesting security subject. SQL Server...
2015-10-13
508 reads
SQL server Encryption – Transparent Data Encryption
In the previous blogs we saw the use of certificates to encapsulate symmetric keys. How it benefits the user by...
2015-10-13
570 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
439 reads
A tSQLt Mistake – Debugging a Test
While I was working on a test the other day, it kept failing. Not a big surprise, but I couldn’t...
2015-10-12
751 reads
Attending PASS Summit? Take a great Tuesday precon!
We’re just two weeks away from the PASS Summit in Seattle, and there is most definitely still time to get...
2015-10-12
613 reads
Argenis Without Borders: Fun For a Good Cause
This is the second year of Argenis Without Borders and the second year that I’m taking part. Last year we...
2015-10-12
524 reads
Thank You for Attending my #SQLSatOrlando Session! Slides, Resources, Recording
SQL Saturday #442 in Orlando, FL has come and gone but what a turn out! The event was excellent, we...
2015-10-12
473 reads
Simplified Session Backups
I have demonstrated how to backup a deployed session to a script previously. In this article I demonstrate how to create Simplified Session Backups.
Related Posts:
PowerShell to Backup XE Session...
2015-10-12
9 reads
Simplified Session Backups
PowerShell exposes scads of information and provides the professional with a formidable tool for the tool-belt. Over the past several...
2015-10-12
483 reads
How to create a database on a network share
If for any reason you need to place the database on a network share and by default this option is off you can follow the way described below: A...
2015-10-12
22 reads
Blogs
Measuring RAG Solutions: Are We Retrieving the Right Information?
A RAG pipeline that answers questions in the demo is not the same thing...
Advice I Like: Lots of Ideas
By Steve Jones
“A multitude of bad ideas is necessary for one good idea” – from Excellent...
Building a DBA Agent for Your SQL Server Estate with MCP
Yesterday I gave a talk for MSSQLTips called “Building a DBA Agent for Your...
Forums
BCA KCP Tumpang (08218200205) WhatsApp
ALAMAT : Jl. Raya Tumpang No.1, Ledoksari, Tumpang, Kec. Tumpang, Kabupaten Malang, Jawa Timur...
Adding new column with DEFAULT
Comments posted to this topic are about the item Adding new column with DEFAULT
How do I connect to a SQL Server database on my ISP?
I've got a web application for my side business. I've added a SQL Server...
Question of the Day
Adding new column with DEFAULT
Which number will the COUNT() return after executing the following statements:
DROP TABLE IF EXISTS #test; CREATE TABLE #test (id INT) INSERT INTO #test (id) SELECT * FROM GENERATE_SERIES(1, 3) AS gs ; ALTER TABLE #test ADD flag BIT CONSTRAINT DF_#test_flag DEFAULT 0; go UPDATE #test SET flag = 0 WHERE id = 1 UPDATE #test SET flag = 1 WHERE id = 2 INSERT INTO #test (id) VALUES (4) SELECT COUNT(*) FROM #test AS t WHERE flag = 0See possible answers