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

Archives: March 2018

Authentication issues with GitHub: An error occurred while sending the request —> System.Net.WebException: The request was aborted: Could not create SSL/TLS secure channel.

This blog post is about an error that you may receive if you’re using git commands in PowerShell and authenticating against GitHub.

My GitHub account uses 2 Factor Authentication so I thought it might be that – however I could use GitHub Desktop fine.

I was cloning a new project… Read more

0 comments, 605 reads

Posted in The Hybrid DBA's Blog on 31 March 2018

Geometry Objects in SQL Server using Latitude/Longitude coordinates

(2018-Mat-31) Support for spatial geometry functions was initially introduced in SQL Server 2008 and then it was greatly improved in Denali (SQL Server 2012) version of the product - https://docs.microsoft.com/en-us/sql/relational-databases/spatial/spatial-data-sql-server

Back then, when I was reading about the spatial features in SQL Server, I wondered where I could use this functionality…

Read more

1 comments, 1,323 reads

Posted in Data Adventures on 31 March 2018

Azure SQL Database Manage Instance

Azure SQL Database Managed Instance is bridging the gap between 0n-premises SQL Server and Azure SQL Database. Azure SQL Database Managed Instance gives you the benefits of Platform as a Service and the scoped configuration of a SQL Server instance. The overall goal of Azure SQL Database Managed Instance is… Read more

0 comments, 671 reads

Posted in Tim Radney - Database Professional on 31 March 2018

Configuration service database design pattern

In many cases, we are required to store configuration values for an application, application functionalities or user-specific parameters. Normally application-level parameters are stored in the configuration files. However, if the parameters values are driving domain or business logic inside of the database call, then making an external call to the…

Read more

5 comments, 273 reads

Posted in SQL Design Patterns on 30 March 2018

Code that writes code

Code that writes code it one of the best productivity tips I can give you.  And no, I’m not talking about ORMs. I’m specifically talking about YOU writing a query, which writes one or more queries. The example I’ll give today is changing database file growth rates. If I want… Read more

1 comments, 480 reads

Posted in SQL Awesomesauce on 30 March 2018

The Journey Begins

Thanks for joining me! Target Audience. Database developers, designers and architects. Background. I am lazy efficient, at least am trying to be. First I coded, and coded, and coded. Over time I realized that I like to code, but more, I like to code smart. So I start to read,…

Read more

2 comments, 254 reads

Posted in SQL Design Patterns on 30 March 2018

Database Doing DevOps

DevOps.  It’s one of the latest buzz words in many technical communities.  Database Doing DevOps  This phrase, however, is NOT heard in many technical communities.

However, it really should be.  Databases doing devops is probably one of the hardest things to tackle in the DevOps world.  With hard work though,… Read more

0 comments, 411 reads

Posted in John Morehouse | Sqlrus.com on 30 March 2018

YouTube Channel Update: March 30, 2018

Hey everyone!

Here’s the latest stuff on my new YouTube Channel. Please let me know if these videos are helpful. Also, if you have requests for videos on a particular topic, even a video of a blog post I did here, let me know. I take requests and I’m… Read more

4 comments, 367 reads

Posted in The Scary DBA on 30 March 2018

SQL Script to find the database & their files details on a SQL Server

Sometimes we need a SQL Script which can gives the below information about the databases created on a SQL Server for house keeping purpose: -

1) Database Name
2) Database ID
3) Database Files name with their physical location
4) Database Creation Time
5) Users access type for Database

Read more

1 comments, 885 reads

Posted in Vivek's SQL Notes on 30 March 2018

Thursday Night at the PASS Summit

It’s early days for thinking about the Summit, but as I wrote the post for yesterday about not submitting I was thinking about Game Night (which I hope continues) and trying to think what else we might do for a small(er) group given that we have rooms available. That took… Read more

0 comments, 433 reads

Posted in SQLAndy on 30 March 2018

SQL Script: - How to find the database restoring history of SQL Server databases

Sometime we need to find out the history of database restoration to get the answers of following questions: -

1) Do we need to restore the database again as there can be a possibility that it is restored recently?
2) Which backup file (with location information) is used for database…

Read more

0 comments, 1,843 reads

Posted in Vivek's SQL Notes on 30 March 2018

Azure SQL Database – Automatic Index Tuning

Introduction: -

We live in an era of “Automation”.  Planes run on auto pilot mode, cars will soon be auto driven, so why not have auto indexed databases? This article will discuss the automatic index tuning feature available in Azure SQL Database.

Problem Statement:

Application development is moving at a…

Read more

9 comments, 794 reads

Posted in SQL and SQL Only on 30 March 2018

Why We’re Organizing SQL Saturday in Wheeling, WV on April 28th

Some of my friends know I am a huge fan of the song “Havana” by Camila Cabello. They also know I like to remix songs and if I was to remix the song I would just change the word “Havana” to “Wheeling, WV” because half of my heart is in… Read more

0 comments, 1,486 reads

Posted in John Sterrett on 29 March 2018

PASS Virtualization Webinar – April 11

I am proud to present a free webinar for the PASS Virtualization virtual chapter entitled “Level Up Your Cloud Infrastructure Skills” on Wednesday, April 11, at 1pm Eastern.

Abstract: Think infrastructure in the cloud is still just for sysadmins? Think again! As your organization moves into the cloud,… Read more

0 comments, 380 reads

Posted in Technobabble by Klee from @kleegeek on 29 March 2018

Interview With Matt Gordon

I’ve been wanting to share a little bit about Matt’s story for a while now and this past week I reached out to him to see if he’d be up for an interview for the blog. As is usually the case he was happy to oblige. I’ve known Matt for,… Read more

0 comments, 838 reads

Posted in The SQL Professor on 29 March 2018

Learning is Hard–March Goals Update

This is the third update for my goals for 2018. This is about 3 weeks after the last update, and it’s too soon. Not in time, but because I haven’t done a great job.

This was a busy month. March and April are prime volleyball season, so I’ve had… Read more

0 comments, 963 reads

Posted in The Voice of the DBA on 29 March 2018

‘Object Reference Not Set to an Instance of an Object’ When Failing Over an Availability Group Using SSMS <= 17.5

Here’s a quickie that I’ve just stumbled across.

I’ve just tried to initiate a manual failover of an availability group and received the following error.

After a spot of head scratching and thinking that there was something wrong with my AG setup, it turns out that there’s a bug in… Read more

0 comments, 465 reads

Posted in SQL Undercover on 29 March 2018

Speaking at SQL Saturday Atlanta (#733)

I am so honored and humbled to have been selected to speak at SQL Saturday Atlanta (#733) on May 19, 2018.  I will be presenting my Data Types Do Matter session.  This will be my second time speaking for this event in as many years.  I was so thrilled to… Read more

0 comments, 364 reads

Posted in SQL Swimmer on 29 March 2018

SSMS now has a vulnerability report

Security is an important and often overlooked function of technology. Don’t believe me? Go to a SQL conference and look how many people are listening to the perf tuning session vs the 3 people attending the security session.

Hopefully, this new feature will help those that are interested and those… Read more

0 comments, 385 reads

Posted in Confessions of a Microsoft Addict on 29 March 2018

SQL Script: - How to find the last access date of a database

Sometime we create databases on Test/ Development database servers for temporary uses for short duration and  forgot to delete them after the work got completed. As a part of house keeping activity, we need to find out when a database is last accessed in order to find out the databases…

Read more

1 comments, 1,232 reads

Posted in Vivek's SQL Notes on 29 March 2018

Older posts