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

Archives: December 2017

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 240 reads

Posted in SQL RNNR on 31 December 2017

Failed to Create the Audit File

One day while checking things for clients, I happened across a fun little error message – “SQL Server Audit failed to create the audit file“. It just so happens that the audit had been working and then suddenly stopped and started flooding the error logs with this message. Read more

0 comments, 405 reads

Posted in SQL RNNR on 31 December 2017

Azure SQL Database - Backup

Most of you must be knowing that backup in Azure SQL Database fully automatic. After the database is created and the database is automatically backed up by Azure. One can restore to any point in time for a period of 7 days for the basic subscription and 35 days for…

Read more

0 comments, 478 reads

Posted in SQL and SQL Only on 31 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 163 reads

Posted in SQL RNNR on 30 December 2017

An Introduction to Templates

Templates are a powerful tool in so many trades and crafts. From decals and stickers all the way up to the largest cruise ships in the world, templates can be found everywhere in just about everything that do.

In SQL Server, templates are readily available for your use in so… Read more

0 comments, 452 reads

Posted in SQL RNNR on 30 December 2017

PLEASE, Please, please Stop Using Impersonation, TRUSTWORTHY, and Cross-DB Ownership Chaining

(last updated: 2018-03-27)

Despite features added in SQL Server 2005 (yes, 2005!) that allow for very flexible, granular, and robust security, it is still quite common for people to be using the older and/or riskier mechanisms of temporarily granting additional privileges.

What follows is an overview of a presentation that… Read more

3 comments, 1,295 reads

Posted in SQL Quantum Leap on 30 December 2017

New Year: 2017 Year in Review

Welcome to gethynellis.com and our final post of the year.



SQL Server 2017 - In Review


It’s the end of what has been interesting  and successful year here gethynellis.com on both the SQL Server consulting and SQL Server training side of the business.


-->
On the consulting front we…

Read more

0 comments, 339 reads

Posted in The SQL DBA in the UK on 30 December 2017

How Not to Sell Software: a Tale of Bad Sales

Naming no names here, but I want to talk about a really horrible sales call I had recently. Well, the horribleness started with the call, but continued afterward. There was part of me that wanted to tell the vendor during the call to put their software someplace protected from the…

Read more

Out with the Old, In with the New

In a few days the year 2017 will come to a close.  The brand new year 2018 is on deck and raring to go. Out with the old, In with the New.

This is the time of year where people reflect on the milestones of the previous year.  Resolutions get… Read more

0 comments, 280 reads

Posted in John Morehouse | Sqlrus.com on 29 December 2017

Out with the Old, In with the New

In a few days the year 2017 will come to a close.  The brand new year 2018 is on deck and raring to go. Out with the old, In with the New.

This is the time of year where people reflect on the milestones of the previous year.  Resolutions get… Read more

0 comments, 138 reads

Posted in John Morehouse | Sqlrus.com on 29 December 2017

GDPR Compliant worden

Op 25 mei 2018 treedt de General Data Protection Regulation (GDPR) in werking. Deze nieuwe Europese privacywetgeving is van toepassing op alle lidstaten binnen de Europese Unie. Het doel hiervan is het aan de burgers teruggegeven van de grip op persoonsgegevens en het beschermen van de privacy. In de praktijk… Read more

0 comments, 40 reads

Posted in SQL Treeo on 29 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

3 comments, 163 reads

Posted in SQL RNNR on 29 December 2017

Audit Domain Group and User Permissions

No matter how simple the task or how versed we are with doing a security audit, it seems like we can always stand to learn just a little bit more. No matter how many times we hand an audit report over to the auditor, there is always “just one” more… Read more

3 comments, 757 reads

Posted in SQL RNNR on 29 December 2017

Power BI Sankey Chart: a case to review your Budget books

(2017-Dec-29) Sankey diagram (chart), named after Matthew H Riall Sankey, is a good visualization tool for information flow within a system. It can also identify main players (contributors) to different stages of this flow, where those stages can be textually described and flow thickness its distribution can be attributed to…

Read more

4 comments, 932 reads

Posted in Data Adventures on 29 December 2017

Presentations & Blogging of 2017 in Review

And here comes the 5th time I am reviewing what happened on the presentation an blogging side of my life, this time focusing on the past year of 2017. Like in the previous years (2016, 2015, for example), I am including the information from the previous years,… Read more

2 comments, 378 reads

Posted in Niko's blog on 29 December 2017

Columnstore Indexes – part 117 (“Clustered vs Nonclustered”)

Continuation from the previous 116 parts, the whole series can be found at http://www.nikoport.com/columnstore/

An important issue I have faced already a couple of times in production servers was the usage of the Nonclustered Columnstore Indexes vs the usage of Clustered Columnstore Indexes. It seems that there is enough confusions… Read more

0 comments, 560 reads

Posted in Niko's blog on 29 December 2017

RegEx in SSMS: A gift for quick code

I had yet another example of how beautiful Regular Expressions can be in SQL coding today, and so I thought I’d share. What I HAD was a set of DELETE statements that might or might not have been executed recently: DELETE FROM dbo.Table1 WHERE val = 1 DELETE FROM dbo.Table2… Read more

6 comments, 483 reads

Posted in SQL Awesomesauce on 28 December 2017

Some New Cool Features in SSMS

SSMS new versions come up with some cool features. The new features provide support for the SQL Server 2008 databases and onward.

Vulnerability Assessment (active from SSMS 17.4)

Right click on a database Tasks -> Vulnerability Assessment -> Scan For Vulnerabilities… will make a scan of your database for possible… Read more

0 comments, 642 reads

Posted in Si vis pacem, para sql on 28 December 2017

Speaking in 2017

I’m done. No more trips (and no more time) to hit any events this year. As I wrote recently, I’m doing less in 2018, so this review might be quite short next year.

In any case, I thought I’d look back at how speaking went in 2017. I have a… Read more

0 comments, 431 reads

Posted in The Voice of the DBA on 28 December 2017

Correlate Trace and XE Events

Several years back, when Extended Events was brand new, it was downright painful to try and convert the classic Profiler or Server Side trace to something meaningful and useful within Extended Events.

That was years ago and really is ancient history now. Microsoft has provided a couple of maps to… Read more

0 comments, 316 reads

Posted in SQL RNNR on 28 December 2017

Older posts