Tags » SQL Security

SQL SERVER – Create Login with SID – Way to Synchronize Logins on Secondary Server

How many times you had a problem where you have deployed a high availability solution, but the application is not able to use database and getting login failed for user after failover? 282 more words

SQL Authority

SQL SERVER - 3 Common Mistakes of Agile Development - Notes from the Field #074

: This is a 74th episode of Notes from the Field series.  Agile is a time boxed, iterative approach to software delivery that builds software incrementally from the start of the project, instead of trying to deliver it all at once near the end. 771 more words

SQL Authority

SQL SERVER - Adding a Master Data Services to your Enterprise - Notes from the Field #072

: This is a 72th episode of Notes from the Field series. Master Data Services is one of the most important but very little explored feature of SQL Server.  948 more words

SQL Authority

SQL SERVER - Marking Filegroup as ReadOnly with SQL Server

My love for writing about ReadOnly databases have pushed me to explore more about this topic. Based on previous blogs, few readers did ask me that they heard about marking filegroups as ReadOnly and they wanted to know how this can be done. 475 more words

SQL Authority

SQL SERVER - SCRIPT - SQL Listening on Dynamic Port?

With every release of SQL Server, sometimes I need to revisit some of the old blogs to see how they have enhanced. This learning experience is an ongoing process and the best way I learn is by doing a search on the blog from time to time. 347 more words

SQL Authority

SQL SERVER - Security Conversations and Notes with a DBA

One of the great things about working in Pluralsight is that I get to meet a lot of people (trust me on this). I am lost for words when it comes to how my day job helps me in achieving some of the coolest things presentations at a number of conferences. 832 more words

SQL Authority

First Rule in Securing Postgres: Don’t Be Dumb

Source: Robert Haas, Chief Architect, Database Server, at EnterpriseDB.

A very popular standalone NoSQL database solution came under criticism about their security posture this week. It’s not the kind of publicity a database company, or any company for that matter, relishes.

649 more words
Postgresql