Notes from the June 2008 oPASS Meeting
Our main presentation was on 'Unlocking the Power of SQL Compact' by Steve Lasker & Ginny Caughey. Went better than I expected...
2008-06-04
415 reads
Blog Posts
Security by Obscurity?
Andy Warren points to a TechNet article about Security by Obscurity and wanted me to post some notes. Let's start...
2008-06-04
942 reads
Managing Money
First, the usual disclaimer: I'm not a financial professional, so take all of the following with a grain of salt...
2008-06-03
738 reads
Replication Error "field size too large"
Yesterday, I was fighting with an error I have never seen in the replication and not much info can be obtained via...
2008-06-03
15,218 reads
World Wild Telescope & Misc Microsoft Stuff
Just took a look at the World Wild Telescope and it looks interesting, perhaps just as importantly looks cool! Don't...
2008-06-03
429 reads
DIY
Last month the LCD screen on our treadmill went out. We bought it last Christmas (06) as a present for...
2008-06-02
726 reads
Reminder - SQLSaturday #4 in Orlando June 7-8, 2008
Last call! We've got a 2 day event running this time. Saturday is the more traditional (it's only #4 after...
2008-06-02
225 reads
Security by Obscurity?
If you're not familiar with the term it means to make something safe/secure by using a trick to hide the...
2008-06-01
194 reads
Now on Twitter
A few colleagues of mine, Andy Leonard, Jason Massie, and Chuck Boyce, are all on Twitter. As a matter of fact,...
2008-05-30
1,512 reads
Security Issue with SQL Server Reporting Services 2008
I have a CTP of SSRS 2008 deployed to one of my servers. Today I built a couple of reports...
2008-05-30
2,529 reads
Blogs
Daily Coping 4 Jul 2022
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQLServerCarpenter Tools
Over the past couple of years, I’ve developed several tools that I’ve been using...
usp_SQLServerCarpenter_Tools_Get_Procedures_Triggers_Missing_SET_NOCOUNT_ON
/* Author:Brahmanand Shukla (SQLServerCarpenter.com) Date:27-May-2022 Purpose:To get all the stored procedures and triggers missing the use of...
Forums
CAST AS DATE Assistance
Can someone let me know why I'm not able to use CAST method to...
Deploying a standalone Azure VM running SQL Server into an availability zone
If i deploy a standalone Azure VM running SQL Server into an availavility zone;...
SQL Server 2014 Question
So I have inherited an older SQL 2014 Server and have been working on...
Ask SSC