Using xp_cmdshell
Haidong continues to point out ideas that might get you thinking about ways you can do more administration with less work. In this article he demonstrates a couple useful tasks you can do with xp_cmdshell.
Introduction to MDX
New Author! This is an introductory level look at MDX geared toward intermediate or higher SQL users. The rate of OLAP usage is lower than it should be - maybe this will be what gets you started using it. Or thinking about it at least!
Top 100 things you don't want the sysadmin to say
Hopefully you never hear any of these from your sysadmin...
Building SQL Server Central
Ever wonder how SQL Server Central.com was built? Ever wonder why the three founders made the decisions they did? Here's a look at some of the choices that were made early on with the discussion forums.
TSQL Virus or Bomb?
Joseph discusses some common and not so common security threats including the possibility of a TSQL virus and bombs planted from within the organization.
Yukon News
This article on CNET has some info about how Yukon affects the MS strategy in other areas.
Review of MySQL/PHP Database Applications
We haven't had a book review in a while and this one may not be of interest to all of you, but we decided to take a chance and post it anyway! As Andy notes in the review, odds are that you'll deal with one or both of these applications sooner or later, might be worth thinking about taking a look at what they can do. (Reviewed)
Automatically Gathering Server Information Part 2
The second part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Automatically Gathering Server Information Part 1
The first part of Steve Jones's series on having SQL Server automatically report information to a DBA.
Using WMI
Get started with using WMI (Windows Mgmt Instrumentation) by seeing two good scripts to start with, one to reboot the server, another to list all the services.
Blogs
SQL Server Security: Always Encryption
By Vinay Thakur
As discussed introduction of Always Encryption blog and initial Encryption at rest as TDE...
SQL Server Security – TDE Encryption
By Vinay Thakur
Transparent Data Encryption(TDE): TDE was initially introduced in SQL Server 2008 Enterprise Edition; this...
A Las Vegas Break
By Steve Jones
Only a little break for me. I’m actually heading to Las Vegas today for ...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers