SQL in the City - New York 2012
Come join Grant Fritchey, Steve Jones and others for a free day of training in New York City on Sept 28, 2012.
A Quick Count
This Friday Steve Jones wants to know if your career is also helping your wardrobe. (This editorial was originally published on Aug 23, 2007. It is being re-run as Steve is on vacation.)
Red Gate Software announces speaker line up for US SQL in the City tour
SQL in the City is a free, full day training and networking event for database professionals. After the success of last year’s event, Red Gate has expanded the event to cover six cities from sea to shining sea, including: New York, Austin, San Francisco, Chicago, Boston, and Seattle.
Why doesn’t ISNUMERIC work correctly? (SQL Spackle)
Another in our series of articles to help you fill in the cracks in your knowledge with SQL Spackle. MVP Jeff Moden shows us how IsNumeric works and how you should use it.
Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services
This white paper provides practical guidance to help BI professionals and decision makers decide whether SQL Server 2012 Analysis Services tabular or multidimensional modeling provides the best fit for your next BI solution.
More CPU Means More Data
Faster CPUs allow us to perform more complex modeling and analysis of variables, and hopefully come up with better decisions. However that more complex analysis means more data.
SSC Clinic: Finding the rogue query
When you're getting spikes of high CPU, it's quite likely it's a rogue query. But how do you find out which query? Grant Fritchey explains, using SQL Monitor.
Ten Things I Wish I’d Known When I Started Using tSQLt and SQL Test
The open-source Unit Test framework tSQLt is a great way of writing unit tests in the same language as the one being tested. In retrospect, after using tSQLt for a while, what are the 'gotchas'; those things that you'd have been better off knowing about before you get started? David Green lists a few tips he wished he'd read beforehand.
Creativity
What if you could stop all work for a month and have people find ways to improve the business? Would you take the chance?
SQL Server Resources - A list
A great list of SQL Server resources that you can use to help you improve your knowledge or ask questions.
Blogs
Prime Day Recommendations
By Steve Jones
It’s Prime Day. A few of my recommendations, since I want to do some...
Fabric for Operational Reporting & SQL Endpoint Trap
With Fabric Mirroring, Microsoft is promoting a nice and appealing story for operational reporting...
Crawl, Walk, Run with Agentic Development of Power BI Assets
If you’ve been watching AI roll through the data community and thinking, “this seems...
Forums
SQL Art, Part 4: Happy 4th of July — A British DBA's Guide to Celebrating a War We Don't Talk About
Comments posted to this topic are about the item SQL Art, Part 4: Happy...
Alamat BCA KCU MATRAMAN Tlp,Cs:0821-8154-393
WA:08218154393 Jl. Matraman Raya No.14-16, RT.2/RW.1, Kb. Manggis, Kec. Matraman, Kota Jakarta Timur, Daerah...
Alamat BCA KCU CIANJUR Tlp,Cs:0821-8154-393
WA:08218154393 Jl. HOS Cokro Aminoto No.56-58, Muka, Kec. Cianjur, Kabupaten Cianjur, Jawa Barat 43215
Question of the Day
Multiple Values Inserted
I have this code on SQL Server 2022. What happens when it runs all at once?
DROP TABLE IF EXISTS dbo.Commission GO CREATE TABLE dbo.Commission (id INT NOT NULL IDENTITY(1,1) CONSTRAINT CommissionPK PRIMARY KEY , salesperson VARCHAR(20) , commission VARCHAR(20) ) GO INSERT dbo.Commission ( salesperson, commission) VALUES ( 'Brian', 12 ), ( 'Brian', 'None' ) GOSee possible answers