Sweat Files and Practice Projects
Today we have a guest editorial from Andy Warren that looks at side projects and how you might actually grow our careers.
Using R to Explore Data by Analysis - for SQL Professionals
What's the best way for a SQL programmer to learn about R? It's probably by trying out various experiments with an interesting set of data, and some helpful suggestions that point out the parallels with SQL. Feodor provides the data and the helpful suggestions. The rest is up to you.
Culture Clashes and Arrogance
A guest editorial from Andy Warren looks at the disagreements between teams in technology.
Stairway to MDX - Level 11: MDX Time/Date Series Functions: PeriodsToDate() and Derivative Shortcut Functions
BI Architect Bill Pearson launches a set of articles surrounding a group of MDX functions specialized to meet the pervasive business need to analyze data within the context of time / date. In this article, we will overview the PeriodsToDate() function, and then we will introduce "shortcut" functions that are based upon it.
Automating A Heartbeat Check Against an Azure-SQL Database Using PowerShell
In this article, Tim Smith goes through a couple of options to automate heartbeat checks against Azure databases. This is useful if you're moved SQL Server databases to Azure and you want to have periodic checks to make sure the databases are responsive.
Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
Data Mining Part 29: Programming with C# and AMO
In this article, we will show some debugging tips for working with C# and the AMO code for working with Analysis Services and the Data Mining Models.
More Regulation Coming?
With no end to company hack attacks in sight, will we get new regulation instead?
Converting Rows to Columns (PIVOT) and Columns to Rows (UNPIVOT) in SQL Server
Learn how to convert row values into column values (PIVOT) and column values into row values (UNPIVOT) in SQL Server.
How do you use change scripts for your database deployments?
Redgate is researching how people deploy their database changes. This is a very quick survey, and there's an opportunity to sign up for a research call in exchange for a $50 Amazon voucher.
Blogs
No Shortcuts for the SQLCMD Batch Terminator: #SQLNewBlogger
By Steve Jones
I was messing around with SQLCMD and I realized something I hadn’t known. I’ve...
Where Is My SQL Agent? Running Scheduled Jobs Against Azure SQL Database
By gbargsley
One of the first things I review when I inherit a new SQL Server...
AgentDBA vs Critical SQL Server
By Arun Sirpal
It’s 07:43. Someone’s already left a message. “Something’s wrong with the DB server.” You...
Forums
Increment a number in a SQL Query based on a value
I have an issue where I have a Bill of Material list of items...
BCA KCU THAMRIN | Tlp/Wa:0817866887
Tlp/Wa_Cs:0817-866-887. Menara BCA, Grand Indonesia, Jl. M.H. Thamrin No.1, RT.1/RW.5, Menteng, Kec. Menteng, Kota...
Alamat kontak resmi BCA KCP Tebet Telp:0818751777
WhatsApp:0818-751-777 Gedung Gajah Tebet, Jl. Dr. Saharjo No.Raya 111 Unit N & O, RT.1/RW.1,...
Question of the Day
Detecting Characters
I have a SQL Server 2022 English default installation on a server. I want to detect if there are any upper case characters in rows and I have this code:
SELECT CustomerNameID,
CustomerName
FROM dbo.CustomerName
WHERE CustomerName = LOWER(CustomerName)
Here is the sample data I am testing with:
CustomerNameID CustomerName 1 John Smith 2 Sarah Johnson 3 MICHAEL WILLIAMS 4 JENNIFER BROWN 5 david jones 6 emily davis 7 Robert Miller 8 LISA WILSON 9 christopher moore 10 Amanda TaylorHow many rows are returned? See possible answers