SQL Server 2008 and SQL Server 2008 R2 are out of extended support as of July 2019, but the end of bug fixes, security updates and ongoing support has far-reaching data privacy implications, as James Boother from Microsoft Gold Partner, Coeo, explains
2019-09-03
The Microsoft SQL Server team has made it easy for you to retrieve the information in a backup file by using a couple of commands. Read on to learn more!
2019-09-03
When the DevOps pipeline does not include the database, the database can become a bottleneck and slow down the delivery of new features. In this article, Robert Sheldon discusses the challenges involved with including the database and how to overcome them.
2019-09-02
Wednesday September 4 14.00-19.00 BST/ 08.00-13.00 Central - Register for our free virtual learning event, to enjoy educational and entertaining sessions from Microsoft MVPs and celebrate 20 years of Redgate.
2019-09-02 (first published: 2019-08-29)
This article gives an example of loading partitioned tables incrementally using SSIS
2019-08-30 (first published: 2017-11-02)
6,387 reads
In this tip we look at a script that you can use to get better insight on your database tables to help you make some decisions about the data and also the structure of the table.
2019-08-30
Transparent Data Encryption (TDE) has been around for a long time. It first appeared in SQL Server 2008, and after a rocky start with some bugs, it has become a regularly used feature for many organizations. While not perfect, it does provide some protection and auditors like to see physical protection features being used. It's […]
2019-08-29
15,720 reads
Kathi Kellenberger continues her series on SSRS. In this article you learn hose to use parameters that let your report users control how the reports are filtered.
2019-08-29
Learn how you can gain estate-wide views of disk space usage, backups and other jobs, and application of recent SQL Server updates and patches, with SQL Monitor 9’s Estate pages. Using this feature, teams can review the overall health of all their servers and databases, identify potential issues before they escalate into real problems, and assign priorities, proactively.
2019-08-28
In this tip we look at some scripts you can use to monitor your database activity and usage based on the size of the SQL Server transaction log backups.
2019-08-28
By Vinay Thakur
This week has training on AI – Cyber security experts – Omar Santos and...
Following on from my previous post on building The Burrito Bot, I want to...
By HeyMo0sh
DevOps is about shortening the system development lifecycle. Plan faster, build faster, test faster,...
Comments posted to this topic are about the item PostgreSQL String Functions Part 1
Comments posted to this topic are about the item Working Better Under Pressure
Comments posted to this topic are about the item Identities and Sequences V
When thinking about the identity property and sequence objects, which of these can generate values before an insert statement is executed?
See possible answers