SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Latest Blog Posts

Webinar: The end of support for SQL Server 2008

Coeo is a partner with Redgate Software. Tomorrow they are hosting a webinar on what your position will be if you are still running SQL Server 2008 or R2 now. Extended support ends next year and now is the time to start your preparations.

Register now and tune in tomorrow,… Read more

0 comments, 79 reads

Posted in The Voice of the DBA on 23 October 2018

Better Keyboard Extensions in Azure Data Studio

I used to use ALT+X to execute queries in SSMS. I spent years with this shortcut, but as I started to present more, CTRL+E felt more natural. I’ve now grown used to that, so when I typed CTRL+E in Azure Data Studio (ADS), I was less than pleased.

Even trying… Read more

0 comments, 80 reads

Posted in The Voice of the DBA on 23 October 2018

Slides and Scripts from IT/Dev Connections

If you attended either of my presentations for this past IT/Dev Connections, here are the promised slides and scripts.

As I mentioned at the presentation, there’s nothing special about the scripts, so feel free to use them as you’d like.

Top Down SQL Server Security (.zip file – 815 KB) Read more

0 comments, 46 reads

Posted in Databases – Infrastructure – Security on 23 October 2018

PASS Summit 2019 or Microsoft Ignite 2019?

It turns out that the 2019 Summit and Ignite will be held the same week in 2019, see this post from Grant for details. It’s definitely a terrible situation for PASS, either compete to some degree (perhaps more for speakers and MS employees than attendees) or try to exit a… Read more

0 comments, 57 reads

Posted in SQLAndy on 23 October 2018

SQL Saturday Lincoln Precon this Friday Oct 26

I’m presenting an exciting preconference training session on Friday, October 26, ahead of the SQL Saturday in Lincoln, Nebraska. This all-day training class, entitled “Level Up Your Cloud Infrastructure Skills“, is designed to help you, the SQL Server professional, ramp up your knowledge so you know… Read more

0 comments, 43 reads

Posted in Technobabble by Klee from @kleegeek on 23 October 2018

Unexpected Shorthand Date Implicit Conversions

I do my best work in the mornings.  Evenings are pretty good too once I get a second wind.

Late afternoon are my nemesis for getting any serious technical or creative work done.  Usually I reserve that time for responding to emails, writing documentation, and brewing coffee.

Some afternoons I… Read more

2 comments, 63 reads

Posted in Bert Wagner on 23 October 2018

DAX – Cumulative Total and Blank Handling

When developing DAX measure, you should be aware that Blank value behavior might be similarly insidious as NULL value in DB. Sometimes it can surprise you as shown in the following example.

You might have been asked to develop new DAX measure which would show a history of all transactions.… Read more

0 comments, 175 reads

Posted in Joyful Craftsmen Blog on 23 October 2018

This is a company that practises what they preach

How good is a company at engaging with their user base? Obviously when things are going great then it’s wins all around for the company and hopefully the people have invested their money in that company’s products…

When things are not going well – I feel this is how you… Read more

0 comments, 96 reads

Posted in The Hybrid DBA's Blog on 22 October 2018

Upcoming #SQLChat on Making the Most of Conferences

This month’s #SQLChat is hosted by Rie Irish (twitter | blog). It’s a timely topic: Making the Most of Conferences. With the PASS Summit just around the corner, this is a great way to get you thinking about your activities and how to get as much out of… Read more

0 comments, 66 reads

Posted in Databases – Infrastructure – Security on 22 October 2018

Time for SQL in the City Summit–Chicago

This week is the last live SQL in the City Summit this year. It’s this Thursday at the Microsoft office in Chicago, and if you’re nearby, you can still register with “stevejones” as the code.

We’ve presented this program in New York and London this month, and we’ll be showcasing… Read more

0 comments, 131 reads

Posted in The Voice of the DBA on 22 October 2018

SQL Server 2019 Big Data Clusters

At the Microsoft Ignite conference, Microsoft announced that SQL Server 2019 is now in preview and that SQL Server 2019 will include Apache Spark and Hadoop Distributed File System (HDFS) for scalable compute and storage.  This new architecture that combines together the SQL Server database engine, Spark, and HDFS into… Read more

1 comments, 227 reads

Posted in James Serra's Blog on 22 October 2018

Why Did a Plan Get Removed From Cache?

I was recently asked if we could tell why a plan was removed from cache. If you read this blog, you know what I’m going to say next. I checked the extended events and there are actually two different events that will tell us information about a plan removed from… Read more

1 comments, 96 reads

Posted in The Scary DBA on 22 October 2018

Some Thoughts on How to Prepare to Serve on the PASS Board of Directors

From time to time I’m asked for advice and insight on running for and serving on the PASS Board. I feel like the answer to that might fill a small book! I don’t have time to write that and I don’t think it would sell a lot of copies anyway,… Read more

0 comments, 61 reads

Posted in SQLAndy on 22 October 2018

How do I look at my error log if SQL won’t open?

Quick and easy post today. Hopefully you’ve opened the error log on a SQL instance. However, what happens if you don’t have the log viewer in SSMS? In fact, the instance won’t come up at all so you really need to see what went wrong.

Fortunately, the error logs… Read more

0 comments, 71 reads

Posted in SQLStudies on 22 October 2018

Azure SQL DB – Failed to update database because the database is read-only

Quite an interesting  situation I found myself in where I was perplexed for about 5 minutes. I was connected to an Azure SQL Database where I was configuring some users where then I executed a query and was presented with … Continue reading

Read more

1 comments, 85 reads

Posted in All About SQL on 22 October 2018

SQL Server 2019

I have written about 2017 here, Last month at Microsoft Ignite FL on September 2018, Microsoft announce they are going to release 2019 early next  year at , same as Oracle 2019. I would be writing more on it in future. … Continue reading

Read more

0 comments, 152 reads

Posted in Vinay Thakur on 20 October 2018

Notes from SQLSaturday #801 (2018)

We wrapped up our 12th SQLSaturday here in Orlando two weeks ago. Overall things went well. Registration was just a little higher than last year at 505. Last year we estimated attendance at 300. This year Kendal really worked to get an accurate count and it came in at about… Read more

0 comments, 97 reads

Posted in SQLAndy on 20 October 2018

Installing Azure Data Studio

Azure Data Studio is the newest tool from Microsoft for working on the data platform. Last year we saw the preview release of this, called SQL Operations Studio. No one liked the name, and as the tools team at Microsoft worked to update the tool, they changed the name this… Read more

4 comments, 330 reads

Posted in The Voice of the DBA on 19 October 2018

SQL Server – Reading BACPAC Files

If you have been reading my blog for a while now you would know that a common technique to move to Azure SQL DB is to use BACPAC files. Just a reminder, see the below image. I had a bacpac … Continue reading

Read more

0 comments, 148 reads

Posted in All About SQL on 19 October 2018

Contextual View Part II or how to hide sensitive data

In this article I continue to explore the ways to secure the data via contextual views and describe the technique of hiding the data in the logical layer utilizing business rules. Click here to read full article.

Read more

0 comments, 158 reads

Posted in SQL Design Patterns on 18 October 2018

Older posts