SQL Saturday - #75 - Columbus
A free one day training event in Columbus, OH on Jun 11, 2011. Come join us and learn about SQL Server.
2011-06-08 (first published: 2011-05-04)
3,762 reads
Articles
Raw Materials - Childish Games
Digitization transforms yet another of our most cherished traditions.
2011-06-07 (first published: 2009-03-25)
9,628 reads
Why System Account is a bad idea for SQL Server Service Account
I'm trying to set up SQL Server and I know that I'm not supposed to use an account that's an administrator on the system, as per best practices. I see that the System account is a possibility, but I've been advised not to use it. Why not? Check out this tip to learn more.
2011-06-07
5,306 reads
SQLServerCentral Best Practices Clinic: Part 4
In this next installment looking at implementing best practices here at SQLServerCentral, Brad McGehee looks at a few performance counters and what they tell us about the performance of our database server.
2011-06-06
4,486 reads
Using SQL Server to collect information from your Oracle server
Using linked connections you can collect system information on your Oracle server from SQL server.
2011-06-06
3,468 reads
Using PowerShell to Manage SQL Server
The purpose of this article is to demonstrate a custom scripting framework which enables the management of SQLServer databases from a Windows PowerShell session and also to extend Powershell’s flexibility by creating a set of commands customized to our needs. I will call this framework comprised of a library of modules and functions specialized to manage SQLServer the DBA profile.
2011-06-06
3,307 reads
Advice from Exceptional DBAs: Do it!
Nominations for the Exceptional DBA of 2011 opened on May 25. Bob Cramblitt spoke with past award winners to find out what has happened to them since receiving the award and to get advice for people thinking about nominating themselves or colleagues.
2011-06-03
2,311 reads
SQL Server Agent Jobs without an Operator
I work in a fairly large and unwieldy SQL Server shop. Our environment is the wild west. I have DBAs and Developers on my team that create SQL Server Agent Jobs all of the time and there is never an operator setup to email anyone based on a failure condition. I know the right solution here is to "tame the wild west" by locking down the environment and setting up a change management process, but I think that is a topic for another day. Can you give me some idea of how to identify the new recently created SQL Server Agent Jobs and Jobs without an operator setup to email us for a failure condition? I would like to receive emails when either of these conditions occur. Check out the solution to this tip to learn how.
2011-06-03
4,386 reads
Can't Connect Remotely to Integration Services
Integration Service is running on rnage of dynamic port and user can’t connect Integration Service remotely.
2011-06-02
7,354 reads
2011-06-02 (first published: 2009-03-18)
10,100 reads
Blogs
The Intersection Between DevOps and FinOps
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Fabric Mirroring doesn’t start copying Rows
A short blog post about an issue with Fabric Mirroring (with Azure SQL DB...
JSON_OBJECTAGG is an Aggregate: #SQLNewBlogger
By Steve Jones
I wrote an article recently on the JSON_OBJECTAGG function, but neglected to include an...
Forums
PostgreSQL String Functions Part 1
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Working Better Under Pressure
Comments posted to this topic are about the item Working Better Under Pressure
Identities and Sequences V
Comments posted to this topic are about the item Identities and Sequences V
Question of the Day
Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers