A community of more than 1,600,000 database professionals and growing
The Voice of the DBA
Technology is here to stay, and those of us working in this business probably realize more than most people how dependent and integrated our lives are with technology. Even in countries that don't have the infrastructure or economies of first world nations are using more and more technology in their lives. Mobile technology seems to be at the forefront of much of what we do, but I'd argue that data is fast becoming more important than the software itself.
The one thing I'm becoming more convinced of is that this article is right: programming is a core skill. It doesn't matter if you're a developer building mobile apps, or a contractor scheduling workers, or a homemaker that wants to balance a budget. While there is software that might help, it seems many people are quick to open a spreadsheet, add some data, and start building formulas. These days the jokes about people not understanding how to program a timer on a DVR are fading quickly as more and more non technical people are using technology to make their lives easier, or perhaps, more complex, as they manipulate data and software.
I suspect the fundamental skill of logically analyzing a problem and coming up with a set of steps to solve it is becoming more important all the time. In many businesses the ability of workers to think for themselves and handle a variety of situations is more desirable than the ability to follow orders. Even in industries where workers need to follow instructions, those instructions might be coming from computers more and more often. There will be a huge gap between workers that can think for themselves, perform data manipulation and make business decisions and those who cannot. That gap might take the form of compensation differences, more or less opportunities, or something else, but in many industries, those that can build their own programs, whether in code or processes they follow, will advance faster and further.
Not everyone will want to be a computer developer, but most everyone can benefit from understanding how calculations and instructions can be chained together to build a process or workflow. With newer generations becoming familiar and comfortable with technology from early ages, my vote would be that we should add programming to the three Rs for future generations.
Many databases have large tables with hundreds of millions of rows. However, many of these tables are simply keeping a log or history data that can be archived and kept outside the user database in a special archive database. More »
In this article, you will learn what query optimisation statistics are and how SQL Server query optimizer uses statistics. You will also learn how to create and manage statistics, and what are the different ways to determine when statistics were last updated in SQL Server. More »
Data warehousing has become a staple of businesses to help make business decisions. From these data warehouses you can develop... More »
Question of the Day
Today's Question (by Naseer Ahmad):
What will be the result of this batch, assuming that Change Tracking is enabled on database?
CREATE TABLE CT
ALTER TABLE CT
Think you know the answer? Click here, and find out if you are right.
We keep track of your score to give you bragging rights against your peers.
This question is worth
2 points in this category: Change Tracking.
We'd love to give you credit for your own question and answer.
To submit a QOD, simply log in to the
Microsoft SQL Server 2012 T-SQL Fundamentals
Master the fundamentals of Transact-SQL—and develop your own code for querying and modifying data in Microsoft® SQL Server® 2012. Led by a SQL Server expert, you’ll learn the concepts behind T-SQL querying and programming, and then apply your knowledge with exercises in each chapter. Once you understand the logic behind T-SQL, you’ll quickly learn how to write effective code—whether you’re a programmer or database administrator.
When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.
I recently worked on a project that needs to convert Notes database to a web project. The first thing is to export data from Notes DB to SQL. Since Notes is NOT a relationship database, after the export, I found the column names are very confusing, so the task becomes how to interpret the relationship between the columns. I decided that it is neccesary to find out every column name in every table and start the analysis from there. I was able to write a script to generate all the columns names and their tables names using this script, I hope you find it helpful.
How to make this block dynamic?
- I'm just not sure how to do it.
When I run:
select @liststr = coalesce(@liststr+',' ,'') + quotename(column_name)
from [server].j3688802s.information_schema.columns where table_name = 'sample'
I get a...
Sorting based on user input..
I have one requirement and need help.
I have a table:
CREATE TABLE MiscItems(ID INT, Description VARCHAR(50), DisplayOrder SMALLINT)
INSERT INTO MiscItems(ID,Description,DisplayOrder)
- I hae to update the tableA. Server names are same in both tables but in tableB we have more Appnames...
Report from Audit table
- I have a table that tracks all changes to employee Roles.
Here is the table with sample data
CREATE TABLE [dbo].[Audit2](
Parsing the XML
- #1)Here is the piece of code
DECLARE @P XML
SET @P = '<Movie>
Running Total Query
- Hi there people,
I'm writting a T-SQL procedure to get a running total over a certain period,
the data may have...
Max of 2 dates
- I search for Date functions for finding the max of the 2 dates. But such function does not exits.
This newsletter was sent to you because you signed up at SQLServerCentral.com.
Feel free to forward this to any colleagues that you think might be interested.
If you have received this email from a colleague, you can register to receive it here.