Superman

Guy Glantser, Data Platform MVP, is the leader of the Israeli PASS chapter and also the CEO and founder of Madeira Data Solutions. His career has been focused on the Microsoft Data Platform for the past 20 years, performing various database roles as either an on-site DBA, an external consultant or a speaker. Guy is involved in many activities in the Microsoft Data Platform community. He occasionally speaks at community events, such as PASS Summit, SQLBits, SQL Saturdays and user groups around the world. He also co-hosts the SQL Server Radio podcast.

DATEDIFF vs. DATEADD

by Superman

Guy Glantser

Let’s talk about the DATEDIFF vs. DATEADD functions in SQL Server. Each one performs a different task. The former calculates...

2017-01-25

13,340 reads

SQL Server DBA Tips that Can Save Your Ass

by Superman

Guy Glantser

On November 9th I presented a session in the PASS Database Administration Virtual Chapter. The title of the session was...

2016-12-12

381 reads

A Recap of PASS Summit 2016

by Superman

Guy Glantser

Yes, it’s that time of the year again. It’s time for the annual PASS Summit. Just like every year, I...

2016-10-31

891 reads

Machine Learning – What is It Good For?

by Superman

Guy Glantser

Machine Learning is a very powerful technology used in the field of predictive analytics. As far as I see it,...

2016-10-20

419 reads

Recap of My 24HOP Session – From XML to JSON

by Superman

Guy Glantser

Yesterday I presented my session From XML to JSON as part of the 24 Hours of PASS online event. There...

2016-09-08

207 reads

Why Would I Want to Use JSON in SQL Server?

by Superman

Guy Glantser

SQL Server 2016 offers built-in support for JSON, in a similar way to the support offered for XML since SQL...

2016-09-04

642 reads

Query Timeout of the Distribution Agent

by Superman

Guy Glantser

Last week I got a call from one of our clients. They issued an ALTER TABLE command in order to...

2016-08-22

3,783 reads

SQL Server 2016 Cumulative Update 1

by Superman

Guy Glantser

On July 25th Microsoft released the first cumulative update (#1) for SQL Server 2016. This is a good reason to...

2016-08-04

324 reads

Who the Hell is Going to Listen to SQL Server on the Radio

by Superman

Guy Glantser

About 3 years ago Matan Yungman contacted me and said he has an interesting proposition. We met and talked about...

2016-07-21

282 reads

We Must Wait for SP1 before Upgrading to SQL Server 2016

by Superman

Guy Glantser

This post is for T-SQL Tuesday, hosted by Michael Swart (blog | twitter). This month’s topic is all about SQL Server 2016

I’ve been...

2016-06-14

257 reads

Blogs

The First Steps: Understanding the Basics of FinOps

As a DevOps professional, I’ve seen firsthand how cloud costs can quickly spiral out...

Monday Monitor Tips: AI Query Analysis

AI is everywhere. It’s in the news, it’s being added to every product, management...

AI: Blog a Day – Day 8: RAG – Retrieval Augmented Generation

By Vinay Thakur

RAG — Retrieval Augmented Generation. we have covered so far — embeddings, vectors, vector...

Read the latest Blogs

Forums

would it be so terrible to install ssms on a few user desktops?

Hi, ssms is free here. I can think of other reasons to do this...

I'm thinking about submitting some articles

By Doctor Who 2

I've written some documentation on using different Markdown types of files on GitHub. It's...

Not Just an Upgrade

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Not Just an Upgrade

Visit the forum

Question of the Day

Restoring On Top I

I am doing development work on a database and want to keep a backup so I can reset my database. I make some changes and want to restore over top of my changes. When I run this code, what happens?

USE Master
BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak'
GO

USE DNRTest
GO
CREATE TABLE MyTest(myid INT)
GO
USE master
RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACE

See possible answers