Don't Hitch Your Wagon To MS Access
I know this might seem like an odd topic on a SQL Server blog, but it's a common and critical...
2014-01-07
1,176 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
416 reads
Reliably Drop A Database In T-SQL Script
I read with interests about Greg Low’s post “Reliably Dropping a Database in a T-SQL Script is Too Hard”, I...
2014-01-07
1,124 reads
January 2014 – Monthly SQL Server Checklist
image source
It’s the first Monday of 2014. Time for a new year and some resolutions to be a better DBA....
2014-01-06
722 reads
Last Weeks Top “Reading” Links #65
It’s Monday time for this week’s weekly link round-up. If you want to catch these links “live” (so exciting), follow...
2014-01-06
1,090 reads
SQL Server Quickie #9 – Clustered Indexes
(Be sure to checkout the FREE SQLpassion Performance Tuning Training Plan, where you are getting week by week via email...
2014-01-06
600 reads
Interview Questions – what to ask the company interviewing you
Previously, I posted a list of interview questions that I ask job candidates. This post is about the questions that...
2014-01-10 (first published: 2014-01-06)
4,147 reads
Predictions for 2014
I love technology predictions because they are usually so wildly inaccurate that at the end of the year it’s pretty...
2014-01-07 (first published: 2014-01-06)
2,579 reads
Cleveland rocks in February!
Heading to SQLSaturday #241
It’s a brand new year, so start it off right. Cleveland is hosting its third SQLSaturday on...
2014-01-10 (first published: 2014-01-06)
1,217 reads
PowerShell – Find OS architecture (32 bit or 64 bit) of local or remote machines Using Powershell
Method 1: Environment Variable
PS:\>$ENV:PROCESSOR_ARCHITECTURE
Method 2: Using Win32_OperatingSystem
ps:\>$computername=’abcd’
ps:\>(Get-WmiObject Win32_OperatingSystem -computername $computername).OSArchitecture
Method 3: Using Win32_Processor
ps:\>$computername=’abcd’
ps:\>Get-WmiObject -Class Win32_Processor -ComputerName $ComputerName| Select-Object AddressWidth
Method 4:[IntPtr]::Size - Gets the...
2014-01-06
2,162 reads
Blogs
A Daily Report from Claude
By Steve Jones
Redgate had some Claude training recently, which I went through as my knowledge has...
A New Word: Gnossienne
By Steve Jones
gnossienne– n. the awareness that someone you’ve known for years still has a private...
Exploring DiskANN: Part I: Understanding the Algorithm before the disk
How I used AI for this postChatGPT to generate images based on info specifically...
Forums
Demo Tracking Dropped Objects
Comments posted to this topic are about the item Demo Tracking Dropped Objects
Randomly Selecting Columns and Rows from a Table or View
Comments posted to this topic are about the item Randomly Selecting Columns and Rows...
How Can SQL Server Detect Application Errors When Developers Can’t?
Comments posted to this topic are about the item How Can SQL Server Detect...
Question of the Day
Getting Database MaiL Profiles
If I want to return information about all Database Mail profiles on my instance from T-SQL, how can I do this?
See possible answers