Flying high on the Big Data hot-air
Today Phil Factor talks about Big Data, and all the hype that's in the news.
2013-07-30
273 reads
Phil Factor
- Interests: Motorbikes, Beer, gardening, conservation, Local history.
How to understand NoSQL Databases
Today we have a guest editorial from Phil Factor that looks at NoSQL databases.
2013-07-29
544 reads
Some Relevant PowerShell Books
Phil Factor leafs through a few of his PowerShell books in his library, and considers which are his favorites
2013-07-29
147 reads
When Windows don’t provide illumination
Microsoft through its various GUIs tries hard to "protect" users from SQL, but Phil Factor argues that we don't need protection from code. We just need a better way to "document" the syntax.
2013-06-10
150 reads
Data Science Sanity Checks
Phil Factor on three "sanity checks" that any data scientist must perform in order to prevent businesses from interpreting data analysis errors, or fraudulent activity, as real trends.
2013-05-13
165 reads
Bad Data Costs Lives
Either data is right or it is wrong. There is no in-between. Phil Factor examines a recent scandal that hit the health care system in the UK to highlight why it's so important that we, as data professionals, ensure responsible use of data and respect for data quality.
2013-04-15
209 reads
NoSQL: Are you ready to compromise with security
Before adopting NoSQL for a commercial application that needs consistency and durability, you need to be satisfied that the product actually provides all those niceties that the user of relational database systems take for granted.
2013-04-01
201 reads
Cloud Services. Waiting for the 'paint to dry'?
Despite recent 'outages', The canny CIO will make use of the obvious advantages of public cloud services where it risks neither security or availability. Adoption of the Cloud services and platforms is going to be most effective where the Cloud’s advantages of rapid scalability can be harnessed.
2013-03-11
85 reads
Not Pulling the Plug Out
Phil Factor on his renewed appreciation for the "customer-focused" culture of the Data Platform Group at Microsoft
2013-01-28
78 reads
The Data Scientist
Phil Factor on why Data Science is about much more than just clever visualizations and big data.
2013-01-21
231 reads
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