-->
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, 331 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, 500 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, 610 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, 240 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, 560 reads

Posted in SQL RNNR on 30 December 2017

Happy new year 2018 to all!

From SQL Guatemala, we wish you a happy new year 2018.

 We hope this new year brings you joy and zero: production outages, corrupted databases, corrupted backups, full disks, and failed nodes hehehehe!

Also we wish for you all your desired certifications, your new software licenses and tools you need,…

Read more

0 comments, 72 reads

Posted in SQL Guatemala 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

4 comments, 1,877 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, 458 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, 374 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, 221 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, 131 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, 243 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, 850 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

14 comments, 1,625 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, 483 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, 761 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, 587 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, 738 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, 523 reads

Posted in The Voice of the DBA on 28 December 2017

Older posts