(Grant Fritchey) As a coder, the more you know about the business, the better code you’re going to write. The more you know about the language in which you code regularly, the better code you’re going to write. Similarly, if you’re tasked with writing code against a relational database engine, you’r
Other News
Integrating SQL Server Data Using Union, Case and Cast in T-SQL
(Dallas Snider) Sometimes we need to integrate data from multiple tables into a single table. While SQL Server Integration Services (SSIS) can handle this task, depending on the situation this integration task could be handled with T-SQL.
Bidirectional Relationships And Many-To-Many In The Power BI Designer
(Chris Webb) There’s a lot of cool stuff in the new Power BI Designer desktop app, but for me the most important new bit of functionality is one that’s not immediately obvious: relationships between tables in the data model have had a significant upgrade. Let me illustrate…
Complimentary Webcast by John Campbell! DB2 11 for z/OS: Technical overview – Part 1
(Surekha Parekh) DB2 11 for z/OS helps secure and manage high-volume business transactions, batch reporting, and business-critical analytics together, in a single environment, and built on the legendary qualities
Creating Complex XML Documents with XML Literals
(Peter Vogel) If you’re creating an XML document and want to write code that you’ll actually be able to maintain … well, it may be time to learn a little Visual Basic, just so you can use XML Literals. It’s a good solution even for C# shops.
Importance of Statistics and How It Works in SQL Server – Part 2
(Arshad Ali) In my last article I discussed the basics of statistics and why it is needed. I also covered when it needed to be created or updated and how it looks. In this article I will talk about how performance gets impacted because of missing and out-of-date statistics, how statistics are manage
Showing File Extensions and Hidden Files in Explorer
(Ged Mead) I really don’t like the way that file extensions are automatically hidden in File Explorer and I also like to know exactly what’s in a folder, so like to see the Hidden files too. I understand that the second feature is to save careless users from doing great damage and have no problem w
Gearing up the Business for Data Analytics–Part IV
Gearing up the Business for Data Analytics–Part IV In the previous articles we were focused on Analytics requirements and data availability for analytics. In this article we delve deeper into the topic and examine whether the available data is of the required quality or not. What is Data Quality? The two most important characteristics that determine the quality of data...
This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Register
Already a member? Log in here
Bringing Your Core Business Applications to SharePoint
(Jonathan Rozenblit) It has been a long time question: should we or not bring our core business applications to SharePoint? What are the benefits? What are the risks? Is it hard? …
(More) Secure local passwords in MySQL 5.6 and up
(Jay Janssen) I log into a lot of different servers running MySQL and one of the first things I do is create a file in my home directory called ‘.my.cnf’ with my credentials to that local mysql instance: