Thoughts on Database Mail
I suspect few would argue that database mail in SQL 2005 is a huge improvement over the mail system in...
2008-04-07
299 reads
Blog Posts
A Note on sp_updatestats
In SQL 2000 when you run sp_updatestats it's the equivalent of running UPDATE STATISTICS on each table, forcing the update...
2008-04-06
413 reads
Jacksonville SQLSaturday less than a month away!
The SQLSaturday in Jacksonville, Florida, will be held May 3, 2008. I'm on track now to give two security based...
2008-04-05
530 reads
SQL Server Forensics Book
I logged into Safari today to download some chapters I want to be able to review when I'm offline. I...
2008-04-05
1,254 reads
Changing Dynamics on a Project Team
MVP Andy Leonard has written a nice post about how the dynamics changed on a project team. Most of it...
2008-04-04
592 reads
Configuring SPN for SQL Server Browser service
Going through the Microsoft KnowledgeBase updates, I saw this one:
An SPN for the SQL Server Browser service is required when...
2008-04-04
2,475 reads
Installing 5.0.51a MySQL Community Edition on Windows Vista
I'm still working on getting all of my tools and apps onto my new laptop, which is running Vista Ultimate....
2008-04-04
2,514 reads
Cheap But Good KVM Switch
I needed a KVM (keyboard-video-mouse) switch for home to let me switch between two machines, found the Trendnet 2 Port...
2008-04-03
323 reads
MVP Award
Yesterday I found out that I am a new SQL Server MVP. I still have the feeling that I am...
2008-04-02
373 reads
Other Thoughts on Brand Building
Just a link today, but a good one on Building a Powerful Reputation that is a nice follow up to my...
2008-04-02
459 reads
Blogs
Finding fields used in a Power BI report in PBIR format with Semantic Link Labs
Have you ever wondered where a certain field is used in a report? Or...
Adding Test data to msdb.sysjobhistory
By Steve Jones
One of our internal people was looking to test some process in (I assume)...
Microsoft Ignite Announcements Nov 2024
By James Serra
Announced at Microsoft Ignite last week were some new product features related to the...
Forums
A Strange Query
Comments posted to this topic are about the item A Strange Query
Primary and Secondary Filegroup
Hello, I am having database primary and secondary filegroup. Few tables/indexes are partitioned on...
Import data from json file with special characters
I am using the following script to import data from a json file. This...
Question of the Day
A Strange Query
What does this return?
SELECT x=1 WHERE (SELECT 1) IN ( 1, 2, 3)See possible answers