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

Latest Blog Posts

Backing up SQL Server on Linux using Ola Hallengrens Maintenance Solution

With the release of SQL Server vNext CTP 1.4 SQL Agent was released for use on Linux. To install it on Ubuntu you need to upgrade your SQL Server to CTP 1.4. On Ubuntu you do this with

sudo apt-get update
sudo apt-get install mssql-server

Once you have CTP 1.4… Read more

0 comments, 111 reads

Posted in SQL DBA With A Beard on 22 March 2017

Delete an Azure SQL Database from PowerShell

Another post for me that is simple and hopefully serves as an example for people trying to get blogging as #SQLNewBloggers.

One of the things I’ve been working on is trying to get my DevOps, continuous delivery pipeline working with Azure. Part of that is a test deployment… Read more

0 comments, 165 reads

Posted in The Voice of the DBA on 22 March 2017

Automating DBCC DBTABLE – obtaining the disk Sector Size

I was recently reading this msdn article on Ghost Records, and it mentioned that you could get the number of ghost records on a page with DBCC DBTABLE… and it also mentioned that you need to be sure that you enable Trace Flag 3604 in order to see the results.… Read more

0 comments, 93 reads

Posted in A Discussion of SQL Server-Related Topics on 22 March 2017

Taking dbatools Test-DbaLastBackup a little further

In a previous post I showed how easy it is to test your backups using Test-DbaLastBackup

Today I thought I would take it a little further and show you how PowerShell can be used to transmit or store this information in the manner you require

Test-DBALastBackup returns an object of… Read more

1 comments, 89 reads

Posted in SQL DBA With A Beard on 22 March 2017

Creating a list of random numbers

I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly an uncommon task, but it’s not as easy as it would seem. The random number function RAND() has a few inherent flaws. And from what I can remember the random… Read more

0 comments, 89 reads

Posted in SQLStudies on 22 March 2017

New SSMS bug?

It seems like SSMS has seen better days. Many developers I have worked with recently complain about Out of Memory issues and other bugs and I personally miss the days of Query Analyzer.

I discovered this issue while working in SSMS on my Surface and I’m wondering if it’s just… Read more

2 comments, 221 reads

Posted in Confessions of a Microsoft Addict on 22 March 2017

Speaking at PowerShell Summit!

Speaking at PowerShell + DevOps Global Summit 2017!

I’m proud to announce that I will be speaking at PowerShell + DevOps Global Summit 2017 on the conference runs from April 9th 2017 through April 12th 2017. This is an incredible event packed with fantastic content and speakers. Check out the…

Read more

0 comments, 82 reads

Posted in Anthony Nocentino's Blog on 22 March 2017

SQL Saturday Richmond (#610)

On Saturday, March 18, 2017, I spoke at my very first SQL Saturday.  I have been an attendee, involved in organizing and volunteered at many over the years, but this was the very first time I was a speaker.  My session, What is Power BI?

I have presented this session… Read more

0 comments, 70 reads

Posted in SQL Swimmer on 22 March 2017

My path from a junior to a senior DBA

A non-technical post but something I have been asked about few times so I thought that I would put pen to paper and tell you about my journey on becoming a senior DBA. You might find it fun to read. Time … Continue reading

Read more

3 comments, 162 reads

Posted in All About SQL on 22 March 2017

Dividend Tax Changes and Brexit – Damaging to UK IT company creation

In my previous post titled UK Budget 2017 –The Death Knell for Small Business? We scratched the surface in discussing how economic decisions made during political events like the budget, can impact on business creation and people’s wiliness to follow their ideas and dreams and start their own business. 2016…

Read more

0 comments, 82 reads

Posted in The SQL DBA in the UK on 22 March 2017

Cumulative Update #2 for SQL Server 2016 SP1

The 2nd cumulative update release for SQL Server 2016 SP1 is now available for download at the Microsoft Downloads site. Please note that registration is no longer required to download Cumulative updates.

To learn more about the release or servicing model, please visit:

Read more

0 comments, 119 reads

Posted in MSSQLFUN on 22 March 2017

The PASS Executive Committee

I was just reading The PASS Board Guidance Policy . Overall a reasonable document and absolutely worth reading if you’re thinking about running for the Board. It is missing what I consider a key point about the Executive Committee, so I wanted to write a quick note on that.

The… Read more

0 comments, 75 reads

Posted in SQLAndy on 22 March 2017

Here I go again

About two years ago I wrote my first blog post.

About a year ago I paused my blogging activity. That’s when I joined Microsoft.

Not that Microsoft forbids its employees to be active in any social networks, quite the contrary. There are however policies and rules to follow. And it… Read more

0 comments, 78 reads

Posted in Gorandalf's SQL Blog on 21 March 2017

Building a Database DevOps Process at the Data Platform Summit 2017

I’m heading to India this August for the Data Platform Summit 2017. I am honored to have been selected to deliver a pre-conference seminar called “Building a Database DevOps Process”, where I’ll walk through the way in which you can include your database alongside application code and deploy it… Read more

2 comments, 132 reads

Posted in The Voice of the DBA on 21 March 2017

The Pen Cap

This post is for all you up and coming data professionals out there. Over the course of the last week we had a T-SQL Tuesday block party which I missed. The beginning of the year is a very hectic time at the shop; doesn’t negate the fact that I… Read more

0 comments, 70 reads

Posted in The SQL Professor on 21 March 2017

Always on\Database Mirroring Automatic Page Repair

A special thanks to Daniel Jones [daniel.jones.0543@gmail.com] for showing up interest and writing informative article for our blog (http://mssqlfun.com/).

 

Always on\Database Mirroring Automatic Page Repair

One of the most useful as well as hottest feature in SQL Server is mirroring of database. It is helpful for numerous of… Read more

0 comments, 89 reads

Posted in MSSQLFUN on 21 March 2017

SSIS Articles on SQLShack

Please check out SQLShack.com for three articles on SSIS. I wrote them based on using the SSIS Catalog and Project Parameters created in SQL Server 2012 and improved on in the next 2 releases. Project parameters are a big deal in SSIS for changing values when executing a package… Read more

0 comments, 74 reads

Posted in The Smiling DBA on 21 March 2017

Power BI Custom Visuals Class (Module 43 – Gantt)

In this module you will learn how to use the Gantt Power BI Custom Visual.  Using the Gantt chart you can easily visualize project timelines and deliverable completion.

Module 43 – Gantt

Downloads

Read more

0 comments, 92 reads

Posted in Devin Knight on 21 March 2017

UK Budget 2017 – The Death Knell for Small Business?

Well I suspect not however I suspect it will likely have a major impact. What has this got to do with SQL and Data I hear you ask? I’m going to provide a little background first. Over the last week or so it has been an interesting political week here…

Read more

0 comments, 109 reads

Posted in The SQL DBA in the UK on 21 March 2017

The parts of an object’s name

Any object within a database in SQL Server has what is called a four part name. Which rather implies four pieces right? Simple enough

Server.Database.Schema.ObjectName

And you can find the lists of each of those pieces in

 
The breakdown is nice but how about usage?… Read more

0 comments, 94 reads

Posted in SQLStudies on 20 March 2017

Newer posts

Older posts