Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Latest Blog Posts

Building Oracle 12c on Linux 7 on Hyper-V

David has written a white paper, or short ebook titled building oracle 12C on Linux 7 VM residing on Hyper-V. The white paper is in draft and has been tested but David would welcome further feedback.

As with everything on this site...The owner of gethynellis.com will not be liable for…

Read more

0 comments, 67 reads

Posted in The SQL DBA in the UK on 19 September 2016

Books VS Internet

It’s is very easy to be confused between investing in books or we should use the power of internet. If you ask my recommendation, I would strongly suggest Books.  Why, let’s take a simple example. Suppose you want to watch a great movie let’s say Avatar. Now you have two…

Read more

0 comments, 6 reads

Posted in Help on MSBI on 19 September 2016

Distributed AG

going though Allan Hirt’s 24 SQLPASS  recording, he has explained the new feature of SQL Server Availability group you can get it here. http://www.sqlpass.org/24hours/2016/summitpreview/Sessions.aspx he is expert in Clustering /AG/ and published several blogs and books. Distributed AG is advance and extended … Continue reading

Read more

0 comments, 106 reads

Posted in Vinay Thakur on 19 September 2016

5 Must Haves Before You Start Consulting

The most common questions I’m asked during networking sessions at technical conferences and events aren’t technical! People want to know what it’s like being an independent consultant. Things like how to get started and what to look out for are common themes.  So I wanted to share the some… Read more

0 comments, 118 reads

Posted in Anthony Nocentino's Blog on 19 September 2016

Azure IaaS Premium Storage Test

I thought I would share the output of some DiskSpd tests that I conducted on Azure VMs that ultimately will have SQL Server installed. I will then show a comparison of the same test on my local (average) machine.

DiskSpd – This is a tool that is provided by Microsoft… Read more

2 comments, 198 reads

Posted in All About SQL on 19 September 2016

Setting DBCC 1222 on startup

The following command is run to gain details on deadlocks.

 DBCC TRACEON (1222,-1)

However, once the SQL instance is restarted this flag is set back to disabled.

To enable it on the instance upon startup:

  1. Open SQL Configuration Manager
  2. Services > Sql Service Instance > Properties > Startup Parameters
  3. Add…

Read more

0 comments, 62 reads

Posted in SQL Barbarian on 19 September 2016

Migrating to Azure SQLDatabase

Right now one of the hottest topics around the world is the cloud and the successful methods for the migration to the cloud. In the world of Microsoft Data Platform and the relational databases, the Azure SQL Database represents one…

Read more

0 comments, 232 reads

Posted in Niko's blog on 18 September 2016

"SQL Server Permissions and Security Principals" at SQLSaturday #560 Charlotte 2016

I'm proud to have been a part of SQLSaturday Charlotte 2016 this year, and happy that I was joined by a number of my colleagues from Sparkhound. We're establishing a presence in Charlotte and already have a couple big clients in the area, so Sparkies from both Baton Rouge and…

Read more

0 comments, 112 reads

Posted in SQL Tact on 17 September 2016

AlwaysON database not synchronizing suspect mode

 

I got a call the database, not online/available mode, we suspect there was a corruption. One of my AlwaysON secondary database went suspect mode, it’s because of the log file and drive was full. I tried to resume the database. ALTER DATABASE dbname SET HADR RESUME;.

It went “in… Read more

0 comments, 151 reads

Posted in SQL Server Blog Forum on 17 September 2016

Open Source PowerShell – Play by Play

What’s going on here?

So last week you may have seen this picture on Twitter…it went a little crazy…and you may have been wondering what are we up to? Well, last week I had the pleasure of filming a Pluralsight Play By Play. A Play By Play is a… Read more

0 comments, 975 reads

Posted in Anthony Nocentino's Blog on 16 September 2016

TGI SQL Friday - 16th September 2016 Weekly roundup

I have had an interesting week teaching Learning Tree course 534 Developing SQL Queries for SQL Server. I had an interesting group from a variety of technical background all wanting to improve their skills in writing queries. Today's the last day, we have had some great questions as the week…

Read more

0 comments, 102 reads

Posted in The SQL DBA in the UK on 16 September 2016

Restoring Azure SQL Database

A major benefit of Azure SQL Database (PaaS) is the fact that Microsoft manages the backups – it’s great because recovering to a point in time is straightforward.

With all editions of the database full backups are taken every week, differential backups are taken hourly, and transaction log backups are… Read more

1 comments, 736 reads

Posted in All About SQL on 16 September 2016

"SQL Server Permissions and Security Principals" at SQLSaturday Charlotte This Weekend!

I'll be presenting my talk on SQL Server Permissions and Security Principals this weekend at SQLSaturday #560 Charlotte, NC.

As a SQLSat veteran and organizer, I regularly receive feedback that there needs to be "more" content at the elementary level for new folks in the field, students, etc. I try…

Read more

0 comments, 119 reads

Posted in SQL Tact on 15 September 2016

Quick #SQLPrompt Tips – Expanding Wildcards

I tend to try and get code on the screen quickly and then start to remove things. I’m a visual person, and it’s helpful for me to see some tables, joins, filters, and columns as I’m structuring a query.

One of the ways I work quickly is with SQL Prompt Read more

0 comments, 155 reads

Posted in The Voice of the DBA on 15 September 2016

#SQLSpeaking this Fall!

I have some great speaking dates coming up this Fall - here is the list:

--









First - the big one.  I am honored to be chosen for the first time to speak at the PASS Summit in Seattle.  The only negative is that I am not on until Friday…

Read more

0 comments, 81 reads

Posted in Nebraska SQL from @DBA_ANDY on 15 September 2016

Emojis in SQL Server

I blame Aaron Bertrand (b/t) and Kevin Kline (b/t). Aaron who posted a great #BackToBasics blog about naming stored procedures and Kevin who tweeted about it.

It’s not my fault. I had to be sarcastic. I had to mention the correct Read more

8 comments, 142 reads

Posted in SQLStudies on 15 September 2016

Power BI Custom Visuals Class (Module 16 – Bubble)

In this module you will learn how to use the Bubble chart Power BI Custom Visual.  The Bubble chart allows you to show the value of categories proportionally represented by the size of the bubble.

Module 16 – Bubble

Downloads

Read more

0 comments, 793 reads

Posted in Devin Knight on 15 September 2016

Great Value IT Training - Awesome ITIL offers

This week's Great Value IT Offers are in. If you want to your ITIL learning on this autumn we have some great deals for you :



995 ITIL® Intermediate: Operational Support and Analysis    3rd October 16

Read more

0 comments, 95 reads

Posted in The SQL DBA in the UK on 15 September 2016

Sql Server - Detecting and Monitoring Memory Pressure

Introduction - Detecting and Monitoring Memory Pressure  I will be writing this article in four parts because this topic is huge and amount of information can be overwhelming for readers and for me also. So we will be exploring it step by step.  DBCC MemoryStatus  Using DMV  Alert and perfmon…

Read more

0 comments, 3 reads

Posted in Help on MSBI on 15 September 2016

More PowerShell for the Azure World

The collection of Azure SQL Database cmdlets can be found at – https://msdn.microsoft.com/en-us/library/mt574084.aspx. There are alot, however I tend to use the following quite frequently and I am sure they will be useful to others too.

Scaling

You can scale your database up or down with the Set-AzureRmSqlDatabase command –… Read more

0 comments, 236 reads

Posted in All About SQL on 15 September 2016

Newer posts

Older posts