Developers who are already familiar with application languages will be baffled by different aspects of PowerShell to the beginner to programming. Laerte recalls his initial struggles with PowerShell and answers those questions he wished he'd found quick answers to.
2016-04-29
4,782 reads
In this article, Marcin Policht describes the basic functionality and implementation steps for Azure SQL Database's Elastic Database jobs.
2016-04-28
5,096 reads
Manvendra Singh explains step by step how to change the server level collation setting for an existing SQL Server instance.
2016-04-27
3,428 reads
In theory, it is easy to determine whether data is equal to, greater than or lesser than a value. Real-world data types can be surprisingly tricky, even for gauging data equivalence. Because SQL cannot remain aloof from any application's data types, you need to be aware of the ways and pitfalls of individual datatypes and how you can test for equality, equivalence, similarity, identity and all that jazz. Joe Celko discusses.
2016-04-26
4,566 reads
Paul Randal continues his knee-jerk performance tuning series, focusing on ways to optimize performance when using temporary tables.
2016-04-25
6,231 reads
You already have a SQL Server Reporting Services (SSRS) sales report that takes parameters for Country and State. Each time the report is run a user selects the specific Country and State for the report. A request has been made to deliver one report via email that includes all of the combinations for each country and state. Daniel Farina shows how to achieve this without modifying the report.
2016-04-22
4,408 reads
By placing under source control everything we need to describe any version of a database, we make it much easier to achieve consistent database builds and releases, to find out who made which changes and why, and to access all database support materials. Matthew Skelton explains how to make sure your version control system fully supports all phases of the database lifecycle, from governance, development, delivery and through to operations.
2016-04-21
4,275 reads
Tim Radney talks about the initial differences he has encountered while mastering the art of performance tuning Azure SQL Database.
2016-04-20
3,285 reads
Have you ever wanted an easier way to provide security at the record level? If so, you can now easily do this with the Row Level Security feature that is being introduced with SQL Server 2016. Greg Larsen shows you how easy it is to use this new feature as a way to provide user access to a specific set of records.
2016-04-19
4,714 reads
Every SQL Server Database programmer needs to be familiar with the System Functions. These range from the sublime (such as @@rowcount or @@identity) to the ridiculous (IsNumeric()) Robert Sheldon provides an overview of the most commonly used of them.
2016-04-18
6,053 reads
By Steve Jones
AI is a big deal in 2026, and at Redgate, we’re experimenting with how...
By Steve Jones
Another of our values: The facing page has this quote: “We admire people who...
By Ed Elliott
Running tSQLt unit tests is great from Visual Studio but my development workflow...
Comments posted to this topic are about the item SQL Server 2025 Standard Developer...
Comments posted to this topic are about the item URL Safe or Not?
Comments posted to this topic are about the item No Defaults Passwords Ever
If I use BASE4_ENCODE() in SQL Server 2025, is the output URL Safe by default?
See possible answers