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
284 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
558 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
164 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
162 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
188 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
228 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
206 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
91 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
91 reads
The Data Scientist
Phil Factor on why Data Science is about much more than just clever visualizations and big data.
2013-01-21
247 reads
Blogs
SSMS Is Getting Smarter—and This Isn’t Just About Writing SQL
Continuing with my takeaways from SQLCon and FabCon Europe in Barcelona, let’s talk about...
Yippee-Kai-Yay 2027 Summit in Denver
By Steve Jones
Next year the PASS Data Community Summit is in DENVER! and London, but Denver...
PASS Data Community Summit 2026
By Steve Jones
Yesterday was the first day of sessions at the PASS Data Community Summit (after...
Forums
Pay for Performance
Comments posted to this topic are about the item Pay for Performance, which is...
Switching Schemas I
Comments posted to this topic are about the item Switching Schemas I
Enforcing Unique Customer Emails When Duplicates Already Exist
Comments posted to this topic are about the item Enforcing Unique Customer Emails When...
Question of the Day
Switching Schemas I
I run this query:
SELECT s.name AS schemaname , o.name AS objectname FROM sys.objects o INNER JOIN sys.schemas s ON s.schema_id = o.schema_id WHERE o.name = 'Beer'I get one row back for an object named dbo.beer. There is an ETL schema and both of these are nonpartitioned tables. I run this code:
ALTER TABLE dbo.beer switch TO etl.beerWhat happens? See possible answers