Stairway to SQLCLR Level 1: What is SQLCLR?
The first step to using the SQLCLR begins with this overview of what is possible and what is not. Start your journey to decide if this is a tool you can use inside your SQL Server instance.
Redgate need users looking to do CI/CD for Oracle Databases
Are you working with Oracle databases or know somebody that is? Does a company or client that you are working with also have an Oracle counterpart? If so, we want to talk to you/them about how they are currently working. We are currently running an Early Access Program (EAP) for a migrations-based solution for Oracle users. Sign up today, get the beta release and let us know your feedback!
Using PowerShell to Generate Logins, Server and Database Permissions
Discover how to reduce the pains you might have feel when migrating all the logins and associated permissions from one instance of SQL Server to another.
Best WordPress Security Practices for 2020
Since many of you choose to host a blog on Wordpress, here are a few things to think about when securing your site. Some of these might also be things you check for your other applications accessing SQL Server.
Working in Smaller Teams
Steve likes working in smaller teams and has some thoughts on why this is important to him.
New Redgate University Courses to Advance your Skills
You may have seen our getting started courses which show you the fundamentals of your Redgate tools. If you are already up to speed and using the tools then you may want to revisit the site as we have added some exciting new courses for SQL Change Automation and SQL Test. These courses aim to give you tips, tricks and ideas on how to utilize your tools to their full potential.
PowerShell and Secure Strings
Greg Moore demonstrates how to work with the Get-Credential PowerShell cmdlet and secure strings when authenticating to an SFTP server.
Using Big Data to Improve Health
With the help of a database that provides fully representative data, we can do a great deal more to advance medical and pharmaceutical science. Phil Factor explains what stands in our way.
Creating a PDF from a Stored Procedure in SQL Server
A short but interesting article, the author has figured out a way to create a PDF from a stored procedure without using a third party library.
SQL Server Integration Services - The New ETL Paradigm
SQL Server 2005 will truly introduce a new paradigm in how developers and DBAs work with SQL Server. One area in which dramatic changes have taken place is DTS, which is now renamed to SQL Server Integration Services or SSIS. Expert author Jamie Thomson brings us a look at how the fundamentals of workflow change from DTS to SSIS.
Blogs
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them
PlanTrace: Stop Reading Redshift EXPLAIN Plans. Start Seeing Them Introducing PlanTrace — a free, browser-based...
A Cloud Dependency Failure from Amazon
By Steve Jones
I went to sleep while reading a Kindle book on my phone. I know...
Deploying AI in logistics (the unfiltered version)
A conversation with Jan Laš, CIO at HOPI, about what deploying a data agent...
Forums
BCA KCU WISMA MILLENIA Tlpn Cs/WA:0821•3111•185
BCA KCU WISMA MILLENIA Tlpn Cs/WA:0821•3111•185 Jalan Letjen M.T. Haryono No.Kav. 16 11, RT.11/RW.5,...
BCA KCP Radio Dalam Telp/WA.0821°3111°179
By Cakhia TV Bóng Đá Trực Tuyến
Telp/WA.0821°3111°179 Jl. Radio Dalam Raya No.5 B-C, Gandaria Utara, Kec. Kby. Baru, Kota Jakarta...
BCA KCP Abdul Muis Telpon/wa:0813.7887.595
BCA KCP Abdul Muis Telpon/wa:0813.7887.595.Gedung Graha Motor City, Jl. Abdul Muis No.24-26 Level I...
Question of the Day
Creating a JSON Document III
I have this data in a table called dbo.NFLTeams
TeamID TeamName City YearEstablished ------ -------- ---- --------------- 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960 5 49ers San Francisco 1946 6 Broncos Denver 1960 7 Seahawks Seattle 1976 8 Patriots New England 1960If I run this code, how many rows are returned?
SELECT TOP 2
json_objectagg('Team' : TeamName)
FROM dbo.NFLTeams;
See possible answers