Dealing with custom date formats in T-SQL
Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.
The Maintenance Poll
This Friday Steve Jones asks about maintenance. Do you have regular windows? Flex time? Or is maintenance just added on whenever it is needed and added onto your work week.
Creating a Map Report in SSRS - SQL Server 2008 R2
SQL Server 2008 R2 brought several new features into the SSRS (SQL Server Reporting Services) arena. In the data visualization category, we now have three additional ways to display and visualize/analyze data in the reports.
A Demo of the Power of Powershell
This demo will show you the how powerfull is powershell. We will use cicles and the get-content command.
A Personality Test
Today we have a guest editorial from Andy Warren as Steve Jones is on vacation. Today Andy talks about personality tests and what they might tell you about yourself.
Managing and Connecting to AlwaysOn Availability Groups
From the previous AlwaysOn Availability Group article, we provided a name for the availability group listener which is simply a unique DNS name as a Virtual Network Name (VNN) to direct read-write requests to the primary replica and read-only requests to the read-only secondary replica.
Basics of XML and SQL Server, Part 3: Transform and Shred XML in SSIS
This SSIS package performs multiple XSL transformations on an XML document, then shreds the transformed document and inserts its data into a SQL Server table.
Data Growth
Today Steve Jones talks about the pace of data growth looking to outpace the IT budget changes. As data professionals, we need to learn to do more with less.
Stairway to SQL Server Replication - Level 9: The Replication Monitor
Introducing the replication monitor and how to use it to monitor replication health. It also introduces tracer tokens.
Attracting Talent
How can a company attract talent? First, be a good company to work for, and then be real.
Blogs
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...
“We love to debate minutiae”
By Brian Kelley
I am guilty as charged. The quote was in reference to how people argue...
Advice I Like: Knots
By Steve Jones
Learn how to tie a bowline knot. Practice in the dark. With one hand....
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