Database Note Taker is a free note-taking app made specifically for SQL databases. It makes a database schema and structures a lot easier to capture and document, and definitely simplifies the database documentation and takes the guesswork out of everyday development with databases. How does it work? More specifically, Connect to your database. Refresh with the current structure of your database. […]
Need a huge SQL database for your data project? Here is one for you. Nick Craver and the kind folks at Stack Overflow publish their data export periodically with your questions, answers, comments, user info, and more. It’s available as an XML data dump. Then, Brent Ozar took the data and imported into SQL Server for his teaching performance tuning needs, and generously published it […]
There are a few ways available to find out what version and edition of SQL Server you are running. SQL Server Management Studio Connect to the server you want to find out, right-click the server instance name and choose Properties. The product line tells what edition of SQL Server this is. It runs SQL Express version in this case. The […]
Brought to you by Idera, here are 17 free SQL database solution tools to improve your everyday database operations, ranging from Monitoring & Performance, Backup & Administration, to Security & compliance. Here is the full list below: Monitoring & Performance SQL Check SQL Fragmentation Analyzer SQL XEvent Profiler SQL Heat Map SQL Hekaton Memory Check SQL Page Viewer SQL Update […]
I just can’t remember how many times I’ve seen this same error popping out to me when I was trying to connect to a new SQL server. And every time when I see this I had to dig into my mind figuring out what to do to solve this. So it’s time to jog down the notes for the next […]