Less and Less Visual
Phil Factor ponders the preponderance of text in current database tools, and asks what happened to our glorious graphical future?
2014-06-26
117 reads
Articles
Continuous Delivery and the Database
Continuous Delivery is fairly generally understood to be an effective way of tackling the problems of software delivery and deployment by making build, integration and delivery into a routine. Phil Factor explains why he's an enthusiast for databases being full participants in this story, and suggests practical ways of doing so.
2014-06-26
5,229 reads
What you need for a Multi Subnet Configuration for AlwaysOn in SQL Server 2012
You have a new project that requires a primary database server in one building and secondary database server in another building to be configured as a Failover Cluster. What are the important points to consider for this scenario?
2014-06-25
3,008 reads
How to Make Scalar UDFs Run Faster (SQL Spackle)
It's a well known fact that Scalar UDFs are the stuff of performance nightmares in T-SQL. But are they really as bad as they say? SQL Server MVP Jeff Moden shows us that they might not really be as big a problem as you might think and what you can do when they actually are.
2014-06-24 (first published: 2012-08-01)
27,850 reads
Differences In Native Compiled Procedures Execution Plans
All the wonderful functionality that in-memory tables and natively compiled procedures provide in SQL Server 2014 is pretty cool. But, changes to core of the engine results in changes in things that we may have developed a level of comfort with. Grant Fritchey explains.
2014-06-24
4,137 reads
Apology for today's article
We'd like to apologize to Gavin Draper who was plagiarized in an article published today.
2014-06-23
5,050 reads
But, but, but, my data is clean!
Gail Shaw on the challenges of trying to extract meaningful data from a database containing customers who have the name 'Dummy **DO NOT USE**''.
2014-06-23
329 reads
Introduction to SQL Server in Microsoft Azure
The convenience, competitive pricing, resiliency, and ease of maintenance of the SQL Database Platform as a Service (PaaS) offering hosted on the Microsoft Azure platform are partially offset by a lack of support for some of the features. These limitations can be eliminated by taking advantage of the Microsoft Azure IaaS capabilities and installing a SQL Server instance in an Azure-hosted VM.
2014-06-23
5,979 reads
Unwelcome posts on our forums
As you may have noticed, we have been suffering recently from increased spam posts on the forums. This is something we're currently working to resolve.
2014-06-20
3,039 reads
My month with Release!
Alex and his team are developing a game about software and some of the people who make it. He looks at how games affected his office culture, what he’s learned about designing games to do more than just be fun, and how his team are hoping to share their passion with the developer community.
2014-06-20
3,352 reads
Blogs
Introducing the SQL Server on Kubernetes Operator
Are you considering replatforming your SQL Server workload due to recent vendor changes, but...
Advice I Like: Rewards from Work
By Steve Jones
The greatest rewards come from working on something that nobody has words for. If...
Overcoming Challenges: Navigating Common Pitfalls in FinOps Adoption
By HeyMo0sh
Working in DevOps, I’ve seen FinOps do amazing things for cloud cost control, but...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
Analysis Services Model w/ Direct Query and (Default Veritpaq)
Analysis Services (either the integrated workspace in Power BI or on a SQL Server)...
Question of the Day
Identities and Sequences IV
When thinking about the identity property and sequence objects, which of these can be used with numeric and decimal data types?
See possible answers