#SQLMaiden 2013 dates
Some time back at a SQL Server user group in Southampton I was speaking to an MVP called Simon Sabin...
2013-01-09
703 reads
Blog Posts
1000 Views on 26 Blog Posts – Thanks a Ton
Thank You all for your support to give me inspiration . It is the result of this that I have achieved...
2013-01-09
447 reads
A Learning Experiment
I’ve been looking for ways to improve the way I do my job, which is mostly writing and editing, but...
2013-01-09
1,165 reads
A Rickety Stairway to SQL Server Data Mining, Algorithm 1: Not-So-Naïve Bayes
Thankfully, the simplest of SQL Server’s algorithms is not quite as naïve about data mining as I am.
As mentioned...
2013-01-09 (first published: 2013-01-04)
6,700 reads
Day 9 of 31 Days of Disaster Recovery: Use All the Checksums
31 Days of Disaster Recovery
Welcome to day 9 of my 31 Days of Disaster Recovery series. Today, I want...
2013-01-09
2,221 reads
Determining Default Trace Location
While working on some scripts against SQL Server’s default trace, I wanted to develop a sure fire way to find...
2013-01-09
1,834 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar...
2013-01-09
8 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific...
2013-01-09
844 reads
Plans for 2013
I have lists. Lots of lists. I even have them in different locations sometimes. Some of them are carefully written...
2013-01-09
906 reads
SQL Saturday #198 Feb 16, 2013
SQL Saturday 198, http://www.sqlsaturday.com/198/ ; is coming to Vancouver Feb 16 this year. As of now, 56 sessions are collected from...
2013-01-09
824 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
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
Server-Level Row Counts for Tables and Views
Comments posted to this topic are about the item Server-Level Row Counts for Tables...
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