Database Weekly is the seven-day roundup from SQLServerCentral. We scour the Internet with a fine-toothed set of queries to compile the most informative weekly newsletter about SQL Server. Over 670,000 SQL Server professionals rely on it to kick-start their week.
Sign up to our newsletter now, to keep up to date with all the latest news.
Latest Database Weekly Newsletter Articles
DB_Owner Querying for Database Options
What can a user with the db_owner database role do? I assumed anything inside of the database (create/alter objects, assign permissions, back up the database, etc). However someone asked recently about whether someone could read database properties. I’d assume they can, but I needed to check.
Adding new users & groups in windows
I do a lot of testing with security in SQL Server. As well as SQL Server logins, I need to be able to create and delete windows users and groups. I could do this with the GUI, but first of all I’m a command line kind of guy and second if I’m creating a dozen or more users at once then the GUI is just too slow.
Database unit testing, are we all doing it wrong?
This week at Redgate HQ we’ve been lucky enough to have a visit from Dave Farley, Continuous Delivery evangelist and co-author of the book Continuous Delivery. When we started talking about database unit testing, we realized we both meant something fundamentally different when we called something a database unit test. Have I been doing it wrong all these years?
SQL Server 2014 Service Pack 1 is available (again)!
As previously communicated, the Service Pack 1 release on April 15 was recalled very shortly after going live on the Microsoft Download Center (only) to address a recall issue. That issue has been resolved, and after complete re-certification is now available.
Using the T-SQL PERCENTILE Analytic Functions in SQL Server 2000, 2005 and 2008
Percentiles give meaning to measurements by telling you the percentage of the population being measured who get higher or lower values. They are now easier to calculate in SQL, and are useful for reporting; but are the new analytic functions faster and more efficient than the older methods? Dwain Camps demonstrates, and investigates their relative performance.
Cumulative Update #6 for SQL Server 2012 SP2
The 6th cumulative update release for SQL Server 2012 SP2 is now available for download at the Microsoft Support site. Cumulative Update 6 contains all hotfixes which have been available since the initial release of SQL Server 2012 SP2.
It’s Hard To Destroy Data
It is surprisingly difficult to delete data permanently. SQL Server has sophisticated features that prevent all kinds of data loss, but the opposite is not true. SQL Server has very few features that help you destroy data.