What's an MVP?
What does it mean to be an MVP for Microsoft? Steve Jones talks about what the award is and what it means to get the award.
2008-07-08
76 reads
Articles
What's an MVP?
What does it mean to be an MVP for Microsoft? Steve Jones talks about what the award is and what it means to get the award.
2008-07-08
65 reads
What's an MVP?
What does it mean to be an MVP for Microsoft? Steve Jones talks about what the award is and what it means to get the award.
2008-07-08
62 reads
Error Handling in Nested Procedures and Logging Custom Errors
Longtime author Leo Peysakhovich brings us a new article on error handling when you have procedures nested inside each other.
2008-07-07
9,350 reads
R-E-S-P-E-C-T for DBAs
Red Gate Software wants to recognize and reward exceptional DBAs with this new program.
2008-07-07 (first published: 2008-05-29)
3,035 reads
Implementing Upgrade of SQL Server 2005 Express Edition
In the previous installment of our series, we presented a variety of reasons that might influence your decision to upgrade a full-fledged member of the SQL Server 2005 family. This article discusses the actual implementation of this process, pointing out additional factors that might affect its complexity.
2008-07-07
1,969 reads
Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-07
51 reads
Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-07
68 reads
Land Mines
Security can be a hassle, but Steve Jones talks about why we sometimes put up with the difficulties of implementing strong security.
2008-07-07
49 reads
SQL Server local disk storage to SANs
Storage area networks (SANs) improve SQL Server performance. Set up SANs on SQL Server with these best practices on migrating to, and configuring SANs.
2008-07-07
4,584 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
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...
Looking for New Blood
Comments posted to this topic are about the item Looking for New Blood
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