The No Good, Terrible Processor Flaw and SQL Server Deployments
You can find this article by Allan Hirt at its original location: http://sqlha.com/2018/01/04/no-good-terrible-processor-flaw-sql-server-deployments-nearly-everything-need-know/
Separation of Duties (SoD) and role-based security conception in SQL Server
/0 Comments/in SecurityIntroduction With the upcoming implementation of the European General Data Protection Regulation (GDPR) in May 2018, having a security concept in place is essentially required by law. Microsoft SQL Server, just like other database systems, carries the main asset to protect: the data itself. Therefore, it is time for an article from a more strategic […]
One day of “In-Memory Technologies in SQL Server”
/in Conferences, HADR, AlwaysOn, In-Memory OLTP/XTP, HTAP, SecurityIt is no secret that I have been very active in the Asian region the last years – mainly in Singapore, Malaysia and India. So, it may not be a surprise that this summer I will be giving a full day PreCon at the now called “Data Platform Summit” in India’s hub for information technology: […]
Where is that Preemptive Wait coming from?
/3 Comments/in Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, Tracing & MonitoringIn this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
Sarpedon Quality Lab presenting SQL Server 2016 In-Memory and Security Features in Arabia at SQL Gulf 3
/in Columnstore Index, Conferences, In-Memory OLTP/XTP, HTAP, Security, SQL Server 2016مرحبا (“MARR-hah-bah”, Arabic: Hello) This year takes me to yet another part of the world: I have been invited to speak at THE SQL Server Conference in the Middle East: at SQL Gulf 3 taking place in Riyadh, Saudi Arabia on April 23rd.
Sessions submitted for major conferences 2016. Topics: Security – Performance – In-Memory
/in Conferences, Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, SQLPASS, Tracing & MonitoringAfter the great success of the German SQLKonferenz in February, where I had the honor of presenting the new security features of SQL Server 2016 together with Joachim Hammer, the Program Manager of the security teams of the relational SQL Engines at Microsoft in Redmond (more info), I finally found time to go about the […]
Schema-design for SQL Server: recommendations for Schema design with security in mind
/0 Comments/in SecurityIntroduction This article picks up a topic I have been teaching time and again in seminars, at conferences and in forums for many years: Schema-Design. Here, schema does not mean the database schema with its tabular design but rather the “database object schemas,” also described as Namespace.
SQLKonferenz in Darmstadt: Presenting the Security Features of SQL Server 2016 with the program manager of the security-teams from Redmond
/in Columnstore Index, Conferences, In-Memory OLTP/XTP, HTAP, Security, SQL Server 2016, SQLPASSThis year, from 23 to 25 February, the 3rd ”SQLKonferenz” takes place in Darmstadt. And this year represents a particular peak for me in two regards: For one, my company, Sarpedon Quality Lab®, is for the first time Silver Sponsor of the conference. In this way, I am supporting PASS Deutschland e.V., the German SQL […]
Security-Fixes for SQL Server and why Security Best Practices Matter
/0 Comments/in Patching, SecurityWith 14 July 2015, quite precisely one year after the first security bugs in 5 years had to be fixed, we have been given a new reason to test one’s security patching policy. – Provided that you have such a policy for SQL Server.
SQL Server 2016 – the Security & Performance Release
/0 Comments/in Columnstore Index, In-Memory OLTP/XTP, HTAP, Security, SQL Server 2016The news broke in early May: That’s when Satya Nadella presented SQL Server 2016 at the Microsoft Ignite-Conference in Chicago. I can already say that SQL Server 2016 will be one of the most exciting releases in recent years. And that’s because this time it’s clearly focused on security. Next to performance features, security features […]
