On Tuesday June 19th 12PM noon Central, Neil Hambly will discuss "Leveraging the power of constraints to improve both data quality and performance of your databases."
2012-06-19
3,690 reads
On Thursday November 17th at 8PM Eastern, Steve Simon will discuss "No Matter how well planned and executed, data structures sometime resembles something out of a Dr. Seuss book."
2011-11-17
1,229 reads
In July start with the following presentations from the AppDev and DBA Virtual Chapters of PASS:
Loops, Lookups and Splits: SSIS Beyond the Basics
Why Should I use Stored Procedures?
2010-07-13
548 reads
Please avoid cross posts. It's really hard to follow. So, where should we continue? Here or here?
2004-03-11
I have a developer using a third-part reporting software. The software uses the sp_executesql stored procedure to obtain results rather than a direct query. I've only seen this used by MS Access when it does queries; I really never paid much attention to it. With some of the limited research I've done, it appears as […]
2004-02-24
13 reads
2004-02-23
I assume you are talking about 70-019, DW for 7.0. I personnally would not spend time studying for this as it will surely go away with Yukon being released later this year. As far as DW---If you want to learn AS then I agree with John, if you want to learn data warehousing, buy Ralph […]
2004-02-19
One way of doing:alter table addupdate the new column with identity columnalter table drop
2004-02-19
"So if I drop and recreate the index in the middle of the operation the users go for a toss."Your create index command will be blocked if the index is being used by user transactions. The user activites will be blocked by recreating index statemnet until indexes are recreated.
2004-02-12
Where are the SQL server logs physically kept. I know you can get to it though EM>database> management>SQL server logs. But one has grown too big. So I issued a new log command (cant remember the actual command at this moment) and it gave me a new log but I want to read the old […]
2004-02-06
1 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers