SQLFacts is a FREE suite of 26 (and counting) tools for SQL Server database development, database administration, and performance tuning. The toolkit is all T-SQL code and it includes the functionality of hundreds of short scripts.
2021-11-19
7,823 reads
In this tip we look at different things you should consider when developing your database systems to ensure you are also thinking about security best practices as well.
2019-01-02
2,792 reads
Today Steve Jones has a few thoughts on the complexity and cumbersome nature of database development.
2017-08-30
86 reads
Phil Factor on dealing with "immutable" domain data during database development and deployment.
2019-08-16 (first published: 2016-01-18)
338 reads
Views can be a great way to abstract away details for clients, but they can also make development much more flexible.
2014-08-01
317 reads
Agile methodologies work well with database developments only if great care is taken to do things right. It requires good judgement and leaves little room for error. Dev Nambi, in an extract from the book Tribal SQL, argues that Agile works for smart, curious, and experienced software engineers.
2014-01-13
5,036 reads
As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.
2014-01-02 (first published: 2013-11-04)
17,207 reads
Often, an existing database application must evolve rapidly by incremental steps. Alex describes a tried and tested system to provide an automated approach to deploying both new and existing database systems, whilst dealing with common security and configuration issues.
2013-03-14
4,602 reads
Today Steve Jones talks about a series of rules he found for database development.
2012-09-17
572 reads
Thanks Steve will work on dbcc next time , but right now i am just finding out why log files are going to data and not into log folder whihc i specify i checked the database settings at bottom of pop u have written and bothe fields are blank RegardsDeepa
2005-05-11
By Steve Jones
Note: I DO NOT recommend this. Any changes to a pipeline should be in...
By Steve Jones
symptomania – n. the fantasy that there’s some elaborate diagnosis out there that neatly...
I recently received a complaint that Query Store for a particular database was turned...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers