Step Up, Don’t Step Back
We have a guest editorial today from Chris Shaw, on the need to take chances in your life.
SQL Server 2014 Backup Basics
There is nothing mysterious about SQL Server backups. They are essential, however you use your databases. Grant Fritchey explains the basics of database backups and restores with SQL Server 2014.
We're not craftsmen and craftswomen
We don't always do the job we would want done for us. We don't pride ourselves as craftspeople do. At least that's what Steve Jones thinks.
SQL Server 2014 Memory Optimization Advisor
The new SQL Server 2014 “Memory Optimization Advisor” tool helps you quickly analyze tables to see how easy it is to migrate them to In-Memory OLTP tables. Read on to learn more.
Double Checks
Many of us have checks in place on systems or processes, but would we be aware of tampering with the operation of our computer systems? Steve Jones notes that auditing can be important to ensure things are working well.
New SQL Monitor Custom Metric: Default User Service Account
Using a default account for SQL Server services can be a security risk for two reasons. Firstly, it can give the service a higher level of permissions than it needs. Secondly, isolation is compromised by several services running under the same account. This metric checks whether SQL Server services are running under any of the default accounts, such as localsystem.
SQL Enlight for SQL Server Management Studio
The process of doing SQL code-reviews used to be tedious and error-prone. Until SQL Enlight, it was a process that was difficult to automate for release and deployment. As it is now both a Command-line utility and an SSMS add-in, the database developer can see immediately the parts of the code that would raise eyebrows with the vigilant production DBA.
No Bosses
The idea of not having a boss appeals to many of us, but is it really what you'd like? Steve Jones notes that Zappos is trying this, by eliminating many of the manager roles at the company.
The Art of Performance
Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.
Agile Database Development
Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.
Blogs
Building the Team: Roles and Responsibilities in FinOps
By HeyMo0sh
In my experience, FinOps success has never been just about tools or dashboards. It...
Tooling for Success: The Best FinOps Tools and Technologies
By HeyMo0sh
As a DevOps person, I know that to make FinOps successful, you need more...
From Planning to Practice: Setting Up Your FinOps Framework
By HeyMo0sh
As someone who works in DevOps, I’m always focused on creating systems that are...
Forums
Restoring On Top II
Comments posted to this topic are about the item Restoring On Top II
SQL Art 2: St Patrick’s Day in SSMS (Shamrock + Pint + Pixel Text)
Comments posted to this topic are about the item SQL Art 2: St Patrick’s...
Breaking Down Your Work
Comments posted to this topic are about the item Breaking Down Your Work
Question of the Day
Restoring On Top II
I have a database, DNRTest, that has a number of tables and other objects in it. The other day, I was trying to mock up a test and ran this code on the same server:
-- run yesterday CREATE DATABASE DNRTest2 GO USE DNRTest2 GO CREATE TABLE NewTable (id INT) GOToday, I realize that I need a copy of DNRTest for another mockup, and I run this:
-- run today USE Master BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO RESTORE DATABASE DNRTest2 FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens? See possible answers