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

Latest Blog Posts

A detailed view into your Azure resources

I’ve been studying Azure recently and came across a really interesting Azure site.

resources.azure.com

To give you an idea why I find this view so interesting I’m going to drill down to a SQL Database that I have.

Up front, you can see some interesting information. The location, status, service… Read more

0 comments, 942 reads

Posted in SQLStudies on 5 January 2017

Clearing Plan Cache in SQL Database (Azure)

Sometimes when in a testing mode I do like to clear cache within my SQL database (Azure). Nowadays a lot of my test databases are Azure based so how I clear cache is different to how I would do it with … Continue reading

Read more

1 comments, 255 reads

Posted in All About SQL on 5 January 2017

Running SQL Queries with Visual Studio Code

Reading this blog post by Shawn Melton Introduction of Visual Studio Code for DBAs reminded me that whilst I use Visual Studio Code (which I shall refer to as Code from here on) for writing PowerShell and Markdown and love how easily it interacts with Github I hadn’t tried T-SQL.… Read more

2 comments, 2,048 reads

Posted in SQL DBA With A Beard on 5 January 2017

gethynellis.com 2016 Review

The year gone was an interesting year for gethynellis.com and GRE Solutions. Any year that has a new release of SQL Server is always an interesting time, as learning and writing about new SQL Server features is always a fun thing to do. David has a great talk that he…

Read more

0 comments, 138 reads

Posted in The SQL DBA in the UK on 5 January 2017

How to attach a new data disk to Azure VM using Azure Portal

In this blog I will tell you how we can attach a data disk to an Azure Virtual Machine using Azure Portal. We can also upload an existing data disk from on-premise data center to Azure and then add that disk as data disk to a VM. Navigate to the…

Read more

0 comments, 234 reads

Posted in Kapil Blogs on 5 January 2017

Sequence – Long awaited feature

As per BOL (https://msdn.microsoft.com/en-us/library/ff878058(v=sql.110).aspx) : A sequence is a user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created. The sequence of numeric values is generated in an ascending or descending order at a defined interval and may cycle… Read more

0 comments, 112 reads

Posted in MSSQLFUN on 5 January 2017

Announcing SQL Saturday Chicago Precon Training Session

Heraflux is proud to announce that I am teaching a preconference training session at this year’s upcoming SQL Saturday in Chicago. The training class is entitled “The Complete Primer to SQL Server Infrastructure and Cloud” and is to be held on Friday, March 10th, at the… Read more

0 comments, 120 reads

Posted in Technobabble by Klee from @kleegeek on 4 January 2017

Quick Prompt Tips–Custom Procedure Templates

One of the things that I often do is create stored procedures. The syntax for doing so is simple, but it has a number of items that need to be included. SQL Prompt makes this much quicker with the “cp” snippet. When I type “cp”, I get this:

I can… Read more

0 comments, 201 reads

Posted in The Voice of the DBA on 4 January 2017

The Side Project

When I first started working as a technologist some 17 years ago, I was doing fairly low-level stuff: moving and reimaging computers, network cabling, and basic desktop support were the extent of my responsibilities. I decided early on that I wanted to move into a more advanced role, but faced… Read more

0 comments, 994 reads

Posted in Tim Mitchell on 4 January 2017

My Interview published on Microsoft Technet Blog

Wish you a Happy New Year to all the readers and technical enthusiasts!!!

https://blogs.technet.microsoft.com/wikininjas/2017/01/02/interview-with-a-sql-server-expert-and-wiki-ninja-prashanth-jayaram/

My interview is published on the Microsoft Technet blog yesterday

 

 


Read more

0 comments, 137 reads

Posted in PowerSQL By Prashanth Jayaram on 3 January 2017

Launching #TAPtips – Valuable Tips from Decades of Practice

While forming Datalere, Carlos and I wanted to continue with our contributions to the community. We have been active in the community for over a decade by running user groups, speaking at local, regional and international events, but have only blogged occasionally.

To continue with the community contributions, we are… Read more

0 comments, 2 reads

Posted in Marc Beacom on 3 January 2017

Be Careful of Your Create Stored Procedure Batch

I was rehearsing a demo with someone recently and we had some stored procedure code that looked like this:

CREATE PROCEDURE UpdateEmpID @empid INT
 AS
 BEGIN
 UPDATE  dbo.Employees
 SET empid = 3
 WHERE  empid = @empid
 ;
 END

However, this was part of a batch that had all of this… Read more

0 comments, 690 reads

Posted in The Voice of the DBA on 3 January 2017

Books of 2016

I set myself a reading goal of 75 books for last year, and managed 73. I’m not overly happy about that, there were months where I barely managed to read anything

The full list, with Amazon links is at the end of this post, I’ll mention a few of the… Read more

0 comments, 154 reads

Posted in SQL In The Wild on 3 January 2017

Checking DBCC CHECKDB

I hope you run consistency checks on your databases, if you are not currently doing this you probably will want to. For this post I want to show you how you can check whether or not CHECKDB has been successfully executed. … Continue reading

Read more

1 comments, 304 reads

Posted in All About SQL on 3 January 2017

My Epic Life Quest

I have always maintained a private bucket list. I have not had the courage to actually put it down in writing – but this year I decided that it is time. My good friend Brent Ozar has been doing this for a few years now, and his list is my… Read more

0 comments, 1,326 reads

Posted in Mala's Data Blog on 2 January 2017

2016 – That was a Year :-)

Its the time of year for reflection and I have had the most amazing 2016, I am blessed that I love what I do so much. I thoroughly enjoy writing and talking and sharing and commenting and supporting and cherishing all the SQL and PowerShell things. I wrote about using… Read more

0 comments, 147 reads

Posted in SQL DBA With A Beard on 2 January 2017

Starting with Chocolatey

I ran across Chocolatey years ago when Scott Hanselman wrote about it in his power tool list. At the time, I wasn’t in need of the tool, but I thought it was cool and tried it. I was hooked.

In fact, the next year I got two different laptops,… Read more

4 comments, 2,291 reads

Posted in The Voice of the DBA on 2 January 2017

Presentations & Blogging of 2016 in Review

For the 4th year in a row, I am keeping data on my professional engagements to help the others –
public presentations, blogging efforts & organisations of the events.

In 2016, I have made my best efforts to reduce travelling and to increase the effectiveness of my presentations. On the… Read more

0 comments, 124 reads

Posted in Niko's blog on 2 January 2017

Microsoft Most Valuable Professional – Data Platform

Today, I’m proud to announce that I have been named a Microsoft MVPData Platform.  This is an exceptional honor and I’m humbled to be included in this group of exceptional data professionals. I really look forward to working with everyone in the MVP community and continuing to… Read more

3 comments, 193 reads

Posted in Anthony Nocentino's Blog on 2 January 2017

Grateful to have been a Microsoft MVP

A couple of weeks ago I received the disappointing but expected news that I wasn’t renewed as a Microsoft Data Platform MVP. I say expected because I knew my ability to give back to the community had been greatly diminished over the later part of 2015 and into 2016. Between… Read more

0 comments, 167 reads

Posted in Databases – Infrastructure – Security on 2 January 2017

Newer posts

Older posts