Data and databases are historically ignored or given a low priority within the processes of ALM and DevOps. This situation needs to change and the primary point of the changes is within the database professional part of the team.
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
This is the last article related to Data Mining in Excel. This last chapter will cover the Analyze section.
Database drift is the difference between two database schemas. Today Steve Jones discusses the concept and wonders how often it happens.
The current popularity of the Salesforce software development platform has taken the industry by surprise. The current IT culture favours the esoteric, yet here is a development platform geared to the idea that anyone can use it: a populist language like BASIC. Does this threaten the careers of professional developers?
Learn how to invoke SSRS reports from an SSIS package after the data load is completed.
This week Steve Jones wonders if you're taking advantage of the changes in the T-SQL language.
It is easy to import Excel data into database tables via TSQL, using OLEDB, either by the OPENROWSET function or linking to the spreadsheet as a server. The problem is that there are certain things that aren't obvious that you need to know about.
Steve Jones completed a task this year that he's rarely completed in the past.
By DataOnWheels
The T-SQL Tuesday topic this month comes James Serra. What career risks have you...
This T-SQL Tuesday is hosted by the one and only James Serra – literally...
By Steve Jones
This month we have a new host, James Serra. I’ve been trying to find...
Comments posted to this topic are about the item OPENQUERY Flexibility
Comments posted to this topic are about the item A Full Shutdown
Comments posted to this topic are about the item Going Native with Fabric Spark...
Which of these are valid OPENQUERY() uses?
See possible answers