Documenting SQL Server Access – Who Can Do What? - Syndication – WaterOx Consulting
When is the last time you audited who has SQL Server access? No really? When did you last do this?...
2016-02-22 (first published: 2016-02-17)
1,694 reads
WaterOx SQL
What’s Going On? A review of 2015 and forecast for 2016 - Syndication – WaterOx Consulting
It’s been quiet… Too quiet Yes, yes it has. Things have been quiet here as of late. Posts and podcasts...
2016-01-06
512 reads
What Alerts Us About The SQL Agent? - Syndication – WaterOx Consulting
The SQL Agent is our friend! Setting up SQL Server Agent to automate jobs and alerts is a great idea....
2015-12-16
714 reads
SQL F.A.D. – Trace flag 834 and columnstore indexes - Syndication – WaterOx Consulting
Trace flags can be good Are special codes we, the DBA, can use to change the way the SQL Server...
2015-12-10
572 reads
020 – A Foolish Decision - Syndication – WaterOx Consulting
Making Foolish Decisions In WOxPod!, episode # 020– “A Foolish Decision” I announce a foolish decision I recently made, and how...
2015-10-16
456 reads
Get Hyper-V Host To Talk To Guest VM’s With This Simple Trick - Syndication – WaterOx Consulting
The Assumption I assume you already have a Hyper-V basic configuration on your system, be it a laptop, server or...
2015-10-16 (first published: 2015-10-07)
1,205 reads
019 – 24 HOP Questions Answered - Syndication – WaterOx Consulting
24 HOP Questions Answered In WOxPod!, episode # 019 – “24 HOP Questions Answered” I answer those questions that I wasn’t able...
2015-10-02
645 reads
SQL Server’s TIMESTAMP Is Not What You May Think It Is. - Syndication – WaterOx Consulting
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...
2015-09-23
979 reads
The Poor Man’s SQL Backup Encryption - Syndication – WaterOx Consulting
Well, that was interesting While playing around with demos to use in my newer session, Hacking Exposé Too (See it...
2015-09-09
449 reads
018 – Learn Like A Pro! - Syndication – WaterOx Consulting
Learn Like A Pro In WOxPod!, episode # 018 – “Learn Like...
The post 018 – Learn Like A Pro! appeared first on WaterOx...
2015-09-04
507 reads
Blogs
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Creating a SQL Stored Procedure to Load a SCD2
By DataOnWheels
This is a blog that I am writing for future me and hopefully it’ll...
Funny Money: #SQLNewBlogger
By Steve Jones
While wandering around the documentation looking for some Question of the Day topics, I...
Forums
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
SQL ART: Who's Blocking Who? Visualising SQL Server Blocking With Spatial Geometry
Comments posted to this topic are about the item SQL ART: Who's Blocking Who?...
Running SQLCMD II
Comments posted to this topic are about the item Running SQLCMD II
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers