SQL Server DBAs are typically quite familiar with security and best practices in Windows but may not understand how security works in Linux. In this article, Kellyn Pot'Vin-Gorman demonstrates how to manage user accounts in Linux and why working while logged in as root is a bad idea.
2018-10-22
2,405 reads
In which you ask your assistant to fetch your coffee, and time them.
2018-10-19
3,120 reads
Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this article, Supriya Pande provides a brief explanation of machine learning and then walks you through creating a sentiment analysis application.
2018-10-18
3,009 reads
In this tip we look at how to use Azure quick start templates as well as how you can customize the templates to meet your needs.
2018-10-17
2,544 reads
Although concerns about ownership and security persist, many companies have embraced cloud services and are reaping substantial financial rewards as a result. Rob Gravelle describes the different cloud database categories, and shows us how to configure an Amazon RDS MySQL database.
2018-10-16
2,171 reads
Defects in software can occur in any phase of the software creation process. The earlier and better they are managed, the easier they are to correct. In this article, Afsana Atar explains defect management, including prevention and resolution.
2018-10-15
2,216 reads
Men Without Hats were awesome. Statistics without histograms are terrible, but now they're easy to find and fix.
2018-10-12
3,200 reads
In this tip we look at how to collect data for Elastic Database Jobs and easily store the data in a central location for analysis and review.
2018-10-11
2,818 reads
Now that the GDPR has gone into effect, many are wondering what will happen in the United States. California is the first state to enact similar legislation, called the California Consumer Privacy Act of 2018 (CCPA). In this article, William Brewer explains the history of the law, what it means for companies doing business with California residents, and how it compares to the GDPR.
2018-10-11
2,871 reads
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
2018-10-10
3,405 reads
By Vinay Thakur
it has been a year since i have not written much on the blog...
By Steve Jones
on tenderhooks – adj. feeling the primal satisfaction of being needed by someone, which...
By DataOnWheels
I have been active in the data community throughout my career. I have met...
Comments posted to this topic are about the item A Quick Restore
Comments posted to this topic are about the item Guarding Against SQL Injection at...
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers